Forum Discussion
Sudharsanan
Helper III
Helper IIIUsing measure as filter to derive another value
Hi Friends, can someone help to filter the value between <70% and >-70% from the created measure? This is the measure created to check the variance and i need to ignore the vaules which gives <70...
Hi Sudharsanan ,
Here are the steps you can follow：
1. Create measure.
Flag = IF( [CoGS adjusted] >=-0.7&&[CoGS adjusted]<=0.7,1,0)2. Place [Flag] in Visual's Filter and set is=1.
3. Result:
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
amitchandak
Super User
Super UserSudharsanan , You need some kind grouping of visual for that example
Calculate([Meausre], filter(Values(Table[Row Column]), [Measure] >-.7 && [Measure] <.7))
You can also check what if
SudharsananThank you amitchandak
this is my case. i want to ignore the line where i have CoGS var >70% and <-70% to show my values for all the columns shown in the screen shot. can you help me please? values shown here is all created with measures.