how to create a slicer for a measure

[joannasokolowsk]

Dear Colleagues,

I am trying to add a slicer for a measure and It doesn't work . Do you know if there is any workaround?  

I was trying to attach the dashboard but I do not see such an option, so I will try to explain it below.  I need to create a slicer for the Relevance measure from the summary table (the same that I have with "%Yes"). This Relevance measure is created based on values in columns ( total hours rating, fee rating, prior yr cem rating, recovery rating) and sheet 1/2/3/4 (the same values from 0.0 to 1.0, value change every 0.5) which are on the slicers.  

Relevance_Measure = FIRSTNONBLANK(Summary[Total hours rating],Summary[Total hours rating])*MAX(Sheet1_1[Column1])+FIRSTNONBLANK(Summary[Fee rating],Summary[Fee rating])*MAX(Sheet1_2[Column1])+FIRSTNONBLANK(Summary[Prior Yr CEM rating],Summary[Prior Yr CEM rating])*MAX(Sheet1_3[Column1])+FIRSTNONBLANK(Summary[Recovery rating],Summary[Recovery rating])*MAX(Sheet1_4[Column1])

[v-alq-msft]

Hi, @joannasokolowsk 

A measure is evaluated in the context of the cell of the pivot table or DAX query. The context of the cell depends on the user selections in the pivot table or on the shape of the DAX query. You are unable to put a measure in the page level filter or a slicer which have effects on all the visuals in the page. You may put a measure in the visual level filter to get the corresponding result.

For further information, you may refer the following threads.

Measure as Slicer - Workaround?  

Use Measure as Slicer 

Best Regards

Allan

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@joannasokolowsk , refer if this can help

https://community.powerbi.com/t5/Desktop/Slicer-MTD-QTD-YTD-to-filter-dates-using-the-slicer/td-p/50...

Or this

https://radacad.com/bookmarks-and-buttons-making-power-bi-charts-even-more-interactive

[parry2k]

@joannasokolowsk no, you cannot use measures in the slicer but can be used in Visual Level Filter.

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!