Forum Discussion
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:
The Activity Name slicer is utilised for a particular activity name (these are unique), which then returns a single relevant value in the "Activity ID" value in the Activity ID slicer (again, unique)..
I would like it to show all relevant values in the top left box, which currently just displays the Activity Name as per the Dax mentioned initially.
Cheers!
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" )
3 Replies
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" )Hi Donerandparmo1
Following up to confirm if the earlier responses addressed your query. If not, please share your questions and we’ll assist further.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.
