Forum Discussion

Sdhn420's avatar
Sdhn420
Icon for Helper IV rankHelper IV
5 years ago
Solved

Filter by Benchmark

Hi all, I need to filter the margin of a table using the bechmarck selected from the slicer. Example - table should display Margin% >=Slicer Selected Value1 && margin% <=Slicer selected value   ...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi Sdhn420 ,

     

    Please use the following formula to create a measure:

    Measure =
IF (
    MAX ( 'Data'[Margin%] )
        >= MIN ( 'Benchmark'[Criteria] ) * 100
        && MAX ( 'Data'[Margin%] )
            <= MAX ( 'Benchmark'[Criteria] ) * 100,
    1,
    0
)

    And apply it to filter pane,set as "=1" like this:

    Here is the pbix file.

     

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

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

Sdhn420 , Add a what if parameter with a range slcier and try a new measure

 

new measure =
var _min = minx(allselected(whatif), whatif[value])
var _max = maxx(allselected(whatif), whatif[value])
return
calculate([Margin %], filter(Values(Table[material]), [Margin %] >=_min && [Margin %] <=_max))