Return multiple values DAX

[Saloni_Gupta]

Hi All,

I want to display all the values after filtering the data based on the current logged in user using the below query:

FilterByViewer = IF(SELECTEDVALUE('Permissions Table'[Email])='Permissions Table'[UserPrincipalName],1,0)

UserPrincipalName = USERPRINCIPALNAME()
and dragging the measure created above in "Filters on this visual" and setting it to 1.

In this case I get only 1 value - any other way to show multiple values?

Also, I dont want to use concatenatex(Table, Table[Value], " ,") because I have to display the values a a slicer so that the user can select each value individually.
Please le me know if more information/data is required from my end.
Thanks in Advance!

[Anonymous]

Hi @Saloni_Gupta ,

What kind of visuals do you put these values in? Text types will summarize data in some visuals.

Best Regards,
Gao
Community Support Team

If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly -- How to provide sample data

[Saloni_Gupta]

Hi,
I have a Permissions table where we will be controlling who can view which page/tab of the report as shown below:

now, based on the current logged in user, I want to display only those pages which that user has access to as a slicer and then user can select and can navigate to those pages only as shown below:

For this purpose, I want the multiple values of Page column to be displayed for each user.
Please suggest how to achieve this ?