Forum Discussion
Solved
How to filter/slice values outside a +/-5% threshold without a calculated column?
Hi all, I have a measure called Ratio that compares actual time to a recommended time for each machine. The interpretation is: Ratio > 1 --> machine is slower than recommended Ratio < 1 --> ma...
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
Ashish_Mathur
Super User
Super UserHi,
Share the download link of the PBI file.