Forum Discussion
Using 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% and >-70%. also i need to use this filter to create other measures as well.
appreciate your support!!
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
4 Replies
Sudharsanan , 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
Thank 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.
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
