DAX measure for getting values in a column based on filter condition

[WinterGarden]

Hi,
I've one filter/slicer, the values in that slicer is based on the below measure.

Activity_Filter =

SELECTCOLUMNS(FILTER('Engagement Activity Code','Engagement Activity Code'[Engagement/Projects] = [SelectedProject]),

"Activity Name",'Engagement Activity Code'[Activity Name])

My requirement is that i need to show only the Activity Names in the silicer which are filtered based on the filter condition

can i add a measure into a slicer visual, if not how to get multiple values in a column by applying filter condition into that table and display those values from that column in the slicer.

[SamWiseOwl]

Hi @WinterGarden 

You want to put the Engagement Activity Code Actvity Name column in a slicer.

Then add a filter to that slicer using your above measure Is NOT blank:

Hope this helps, if it does please mark as a solution for others to find 🙂

[WinterGarden]

Hi @SamWiseOwl,

it seems like i cant add that measure to the slicer feild.

[SamWiseOwl · Accepted solution]

Hi @WinterGarden 

You can't put the measure directly into the slicer no.

Instead put your original column into the slicer: Engagement Activity Code'[Activity Name]
Then in the FILTER PANE put your measure: [Activity_Filter] filter this to IS NOT BLANK

[WinterGarden]

My requirement is that i need to show only the Activity Names in the silicer which are filtered based on the filter condition
'Engagement Activity Code'[Engagement/Projects] = [SelectedProject]
if i directly use that 'Engagement Activity Code'[Activity Name] column , how can i filter the values in it bsed on the above condition?

[SamWiseOwl]

I have made a mock up here: Measure as Slicer filter.pbix

Please have a look and let me know what is different and/or provide some data that will help me understand your issue.

Cheers!

[WinterGarden]

It worked!! 
Thank you so much 🙂

[SamWiseOwl]

It's a fun trick, thanks for asking!