Measure greater/less than button

[Anonymous]

Hello,

I have a KPI calculated by different aggregation levels ( it can't be a calculated column).

The idea would be 2 buttons, one the >50 and the other one <50.

It works perfectly doing this, but i was wondering if its possible to replicate this same filter with dax ( I have tried many things) : 

Any ideas ? 

Thank you very much!!

[v-juanli-msft · Accepted solution]

Hi @Anonymous 

Create a measure

Measure = IF([Kpi]>50,[Kpi])

You could also create a what-if parameter, than click on the "down" arrow to select type of slicer.

Then create a measure

Measure = var mins=MIN(Parameter[Parameter]) var maxs=MAX(Parameter[Parameter]) return IF([KPI]<=maxs&&[KPI]>=mins,[KPI])

Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[DataZoe]

@Anonymous have you tried something like this

1. Create a table (enter data) with >=50 and <50 (KPIToggle and column called Toggle)

2. Create new measure

KPI Filter =
SWITCH (
    SELECTEDVALUE ( KPIToggle[Toggle] ),
    "<50", FILTER ( VALUES ( [RegionName] ), [KPI] < 50 ),
    ">=50", FILTER ( VALUES ( [RegionName] ), [KPI] >= 50 ),
    [KPI]
)

 3. use that measure in your table

[Anonymous]

Thanks for answering,

I have tried that, but since [KPI] is not a column but a measure, that approach does not work. 😞 

[DataZoe]

@Anonymous usually when measures are checked inside the filter() it works ok for me. If you have sample data it would be easier to help.