How to display inactive users in eazyBI?

[Daniil Mazurin]

Hi people, i have no idea how ti display unactive users which looks like: Donald Trump [X] (inactive) . How i can make it in eazybi with only deactivated users? 

This is an example of formula whick doesn't work, it display in column "Assigne", but not name of user:

[Daina Tupule eazyBI]

I would suggest creating a calculated member in Assignee dimension. If you would like to address the assignee by name, you would like to use the Name attribute of the member. Here is an example formula:

Aggregate(
Filter([Assignee].[User].Members,
[Assignee].CurrentMember.Name MATCHES '.*[X].*'
)
)

You can add the calculated member to Rows and expand it to see Inactive users.

Daina / support@eazybi.com