Using measure as filter to derive another value

[Sudharsanan]

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!!

[Anonymous · Accepted solution]

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]

@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

https://docs.microsoft.com/en-us/power-bi/desktop-what-if

[Sudharsanan]

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.

[Anonymous]

Hi @Sudharsanan ,

Appreciate if you are able to provid your code sample here.

Regards

Dax_Noob