Forum Discussion

luisccmm's avatar
luisccmm
Icon for Helper II rankHelper II
5 years ago

Dax filter by measure value

Hi, I need to filter measure Value_rank_2000 by measure is_in_rank_2000 =1. But seems I cannot filter a measure by another measure value. Any idea how to accomplish this??   value_rank_2000 =...
Need Help
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

luisccmm , what are you trying to achieve here, Rank is context-based and some context needs to there to the filer. Measure filter need a context to pushed in formula or it will take from rows. 

 

 

refer these examples

 

Rank Top 10= CALCULATE(if([City Rank]<=10,[Sales],BLANK()) ,VALUES(Geography[City]))
Rank Top 10 1 = sumx(VALUES(Geography[City]),if([City Rank]<=10,[Sales],BLANK()) )
Top 10 City Rank = CALCULATE([Sales],TOPN(10,all(Geography[City]),[Sales],DESC),VALUES(Geography[City Id]))
Rank 2nd top = sumx(filter(VALUES(Geography[City]),[City Rank]=2),[Sales] )