Forum Discussion

cillejs's avatar
cillejs
New Member
9 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
    9 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 

v-aatheeque's avatar
v-aatheeque
Icon for Community Support rankCommunity Support
9 months ago

Hi cillejs 

We wanted to follow up to check if you’ve had an opportunity to review the previous responses. If you require further assistance, please don’t hesitate to let us know

v-aatheeque's avatar
v-aatheeque
Icon for Community Support rankCommunity Support
9 months ago

Hi cillejs 

Have you had a chance to look through the responses shared earlier? If anything is still unclear, we’ll be happy to provide additional support.