Use of measure in slicer

[bilingual]

Hi, i would like to add a slicer where "percentage of total" is the value, however i can not make slicer work with meausure, any good hints? f

Fr example make a slice of following data,

So if slicer is set to include more than 14 percent, Name of operator A will be filtered out.

Name of operator	Numbers
A	144
B	557
C	333

[v-yueyunzh-msft · Accepted solution]

Hi , @bilingual 

Here are the steps you can refer to :

(1)My test data is the same as yours.

(2)We can create a "Numeric range" parameter:

(3)Then we can create a measure to control the display of the data:

Flag = var _min_slice = MIN('Percentage'[Parameter])
var _max_slice = MAX('Percentage'[Parameter])
return 
IF(DIVIDE( SUM('Table5'[Numbers]) , CALCULATE( SUM(Table5[Numbers] ) , ALLSELECTED( 'Table5'))) > _min_slice/100 && DIVIDE( SUM('Table5'[Numbers]) , CALCULATE( SUM(Table5[Numbers] ) , ALLSELECTED( 'Table5'))) < _max_slice/100 , 1, 0)

(4)Then we can put the measure in the "Filter on this visual" and configure it and we can meet your need:

Best Regards,

Aniya Zhang

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

[AnastasiaS]

Hello @bilingual,

In some cases an approach could be using the What-if Parameters. Check this article:

https://learn.microsoft.com/en-us/power-bi/transform-model/desktop-what-if

You could define a "number range parameter", for example from 1 to 100, and based on the selected value, add a measure that will check if your values are less or more than the selected one.

You can get this kind of result (the Parameter can also be shown as a dropdown or classic list):

Regards,

[Greg_Deckler]

@bilingual In general, to use a measure in that way, you need to use the Disconnected Table Trick as this article demonstrates: https://community.powerbi.com/t5/Community-Blog/Solving-Attendance-with-the-Disconnected-Table-Trick...