Forum Discussion

Saloni_Gupta's avatar
Saloni_Gupta
Helper I
3 years ago

Return multiple values DAX

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!

Need Help

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    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's avatar
      Saloni_Gupta
      Helper I
      3 years ago

      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 ?