Forum Discussion

Donerandparmo1's avatar
Donerandparmo1
Icon for Helper I rankHelper I
7 months ago
Solved

Display Relevant Filter Values based on a single selection

Hi All,   I am currently using this to display the selected value of a single slicer:     I am looking to show the other relevant values based on a selection from this filter, as such:...
Need Help
  • rohit1991's avatar
    rohit1991
    7 months ago

    Hii Donerandparmo1 

     

    Your current DAX only returns the selected Activity Name, not the related values. To show all relevant values based on that selection, you need to remove the filter from the display column and keep only the slicer context.

    Use this:

    Activity Name Display =
IF(
    HASONEVALUE(DimP6ActivityName[Activity Name]),
    CONCATENATEX(
        VALUES(DimP6ActivityName[Activity Name]),
        DimP6ActivityName[Activity Name],
        ", "
    ),
    "ALL"
)
v-aatheeque's avatar
v-aatheeque
Icon for Community Support rankCommunity Support
7 months ago

Hi Donerandparmo1 

Following up to confirm if the earlier responses addressed your query. If not, please share your questions and we’ll assist further.

  • v-aatheeque's avatar
    v-aatheeque
    Icon for Community Support rankCommunity Support
    7 months ago

    Hi Donerandparmo1 

    We wanted to follow up to check if you’ve had an opportunity to review the previous responses. If you require further assistance, please don’t hesitate to let us know.