Filter on measure

[bo_afk]

Is it possible to filter a table where one measure is larger or smaller than another measure?

[amitchandak · Accepted solution]

@bo_afk , yes but that need row context and all the measures should follow that

1. Option 1.

Create a flag measure if([M1]<[M2],1,0)  , use this as table level filter

2. Option 2, for all measures

sumx(values(Table[ID]) if([M1]<[M2],[Measure],blank() ))

[bo_afk]

Hi @amitchandak, option 1 looks to work best. Thanks for the suggestion!