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])='Permi...
Need Help
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 ?