How to use Measure as Between Slicer

Question

Hello Community.&nbsp;&nbsp;I need your help on this. I have a measure to gives a value 0 to 100. I would like to have a between slicer for that measure. and I want to have a score card to display count of Individual. The Score card and the measure to count is not a problem. I am havin hard time changing the measure to slicer.&nbsp;&nbsp;&nbsp;Any help? please&nbsp;

amirabedhiafi · Answer

What does the measure calculate ?Is it possible to transform it to a calculated column ?

amirabedhiafi · Answer

This cannot be done. Filters ( including slicers) have to come from existing tables, which are only updated at data refresh and not when measures are called.https://www.youtube.com/watch?v=djLX6IUWVwY

tworku · Answer

I have 3 Measures that uses WhatIf. I am required to have the total of those 3 Measures to be filtered by between Slicer.

We can not transform it to calculated column since the measure is the total of those 3 whatIF measure. They want to play around with value of those Whatif measures.

Selected different value from the WhatIF Slicers

Because of this, The Total forcast change depending on the selection.

What they want is to see how many IDs fall in to catagories by changing the "Total Forcast" range. Like the following example

v-janeyg-msft · Answer

Hi,&nbsp;TWorku&nbsp;
&nbsp;
You can try:
measure =
COUNTROWS (
    FILTER (
        SUMMARIZE (
            ALL ( TABLE ),
            [Id],
            "F1", [Forecast 1],
            "F2", [Forecast 2],
            "F3", [Forecast 3],
            "Total", [Total Forecast]
        ),
        [Total] &gt;= MIN ( table2[Total Forecast] )
            &amp;&amp; [Total] &lt;= MAX ( table2[Total Forecast] )
    )
)

Did I answer your question? Please mark my reply as solution. Thank you very much.If not, please feel free to ask me.Best Regards,Community Support Team _ Janey
&nbsp;

tworku · Answer

I think you did not understand what I am lookin for. My goal is to find a way to use a measure as a Between Slicer.&nbsp;My table has ID numbers. Based on activity, each ID Numbers, get a value.&nbsp;Activity 1 has a default of 10Activity 2 has a default of 30Activity 3 has a default of 60&nbsp;I Created 3 what if measures. because what if the user want to change the default value for each activities?&nbsp;&nbsp;Forcast 1 - it is for Activity 1 and the whatif range is from 5 to 15. Default = 10Forcast 2 - it is for Activity 2 and the whatif range is from 25 to 35. Default = 30Forcast 3 - it is for Activity 3 and the whatif range is from 45 to 60. Default = 60I have Total Forcast Measure. it is a total of all the 3 forcasts.&nbsp;So what I am requested is, to use Total Forcast Measure as a between slicer. user can use the default value or can select any of the option from the forcast slicers. the total also change as the slicers selection changes.Thank you for taking time to help on this challenge&nbsp;

Forum Discussion

How to use Measure as Between Slicer

7 Replies

Related content

Slicer on measures

Add Measures to Slicer

Measure as a slicer

Parameter slicer with measure for multiple columns

Slicers on Aggregated Measures