Forum Discussion

Chris741's avatar
Chris741
New Member
9 years ago
Solved

Cannot use measure in slicer

Hello,   I have created a measure which returns the text 'Slow' or 'Fast'. I want to use this measure in a slicer, but Power BI blocks this.   My objective is to filter the underlying table (whic...
Need Help
  • v-jiascu-msft's avatar
    v-jiascu-msft
    9 years ago

    Hello Chris741,

     

    A measure can't be used in clicer directly. You can try this.

    1. Create a table named "ForSlicer" like this (sign 1 in the pic).

    Pareto_SalesUnits_Name    SlicerValue
    Slow Mover                           0
    Fast Mover                            1

    2. Create a measure as below. Maybe you need to make some change.
    Pareto_SalesUnits_Name =
    IF (
        HASONEVALUE ( 'ForSlicer'[Pareto_SalesUnits_Name] ),
        IF (
            VALUES ( 'ForSlicer'[SlicerValue] ) = 1,
            IF([SalesUnits_CumPerc]>[Pareto_BM],BLANK(),"Fast mover"),
            IF([SalesUnits_CumPerc]>[Pareto_BM],"Slow mover",BLANK())
        ),
        IF([SalesUnits_CumPerc]>[Pareto_BM],"Slow mover","Fast mover")
    )

    3. Create a clicer using column "Pareto_SalesUnits_Name" in table FORSLICER (sign 2 in the pic).

    4. Set the visual level filter of the measure "Pareto_SalesUnits_Name" to "is not blank". (sign 3 in the pic).

    5. It works though it's not perfect. Hope this would be a little help.

     

     

     

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Is it possible to create a slicer for multipal measures selection (to pick one each time, from the same table)? 

StidifordN's avatar
StidifordN
Icon for Helper III rankHelper III
7 years ago

Also curious if this method can be used with 3 items... in my case "Non Compliant", "Compliant" and "< $100k".

The Non Compliant works perfect.  This is Value 2 in the created table, Value 3 is 'Compliant' - where does this fit into the formula... if it can.

 

Measure99 = IF(HASONEVALUE('CompliantSlicer'[ComplianceFlag]),
            IF(VALUES(CompliantSlicer[Value])=2,
            IF([CurrentCompliantYN_V2]="Non Compliant","Non Compliant",blank()),
            IF([CurrentCompliantYN_V2]="Non Compliant",BLANK(),"N/A")),
            IF([CurrentCompliantYN_V2]="Non Compliant","Non Compliant","N/A"))