Forum Discussion

bo_afk's avatar
bo_afk
Icon for Post Patron rankPost Patron
5 years ago
Solved

Filter on measure

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

Need Help
  • amitchandak's avatar
    amitchandak
    5 years ago

    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() ))

2 Replies

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    5 years ago

    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() ))