Forum Discussion
How to filter/slice values outside a +/-5% threshold without a calculated column?
cillejs , Upper and lower bounds meausres
Lower = Minx(allelected(' Efficiency Ratio'), ' Efficiency Ratio'[Value])*.95
Upper = Maxx(allelected(' Efficiency Ratio'), ' Efficiency Ratio'[Value]) *.105
More than Upper = Sumx(Filter(Table, [Measure] >[Upper]), [Measure])
Less than Lower = Sumx(Filter(Table, [Measure] <[Lower] ), [Measure])
Assume you already have measure of column to check value with
Super Usercillejs , A calculated column can not use slicer value. You can create a measure. If required a line level measure using sumx or countx
Sumx(Table, Table[QTy]* [Selected Efficiency Ratio] )
Sumx(Table, Table[QTy]* [Selected Efficiency Ratio] )
Where Selected Efficiency Ratio is measure created for selected value of Parameter
of you can use MIn and max Value
Min Val = Minx(allelected(' Efficiency Ratio'), ' Efficiency Ratio'[Value])
Max Val = Maxx(allelected(' Efficiency Ratio'), ' Efficiency Ratio'[Value])
Again, these two can be used in a measure
amitchandak thank you for your quick reply.
I am not sure I understand🙂
I want to be able to toggle between the threshold and ALL values-
I want a fixed +-5% value, not a dynamic range picker.
Thank you
- amitchandak
cillejs , Upper and lower bounds meausres
Lower = Minx(allelected(' Efficiency Ratio'), ' Efficiency Ratio'[Value])*.95
Upper = Maxx(allelected(' Efficiency Ratio'), ' Efficiency Ratio'[Value]) *.105
More than Upper = Sumx(Filter(Table, [Measure] >[Upper]), [Measure])
Less than Lower = Sumx(Filter(Table, [Measure] <[Lower] ), [Measure])
Assume you already have measure of column to check value with