Forum Discussion

cillejs's avatar
cillejs
New Member
8 months ago
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...
Need Help
  • amitchandak's avatar
    amitchandak
    8 months ago

    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 

cillejs's avatar
cillejs
New Member
8 months ago

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's avatar
amitchandak
Super User
8 months ago

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