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
Hi Sudharsanan ,
Appreciate if you are able to provid your code sample here.
Regards
Dax_Noob