Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Visual pane filter messes up ranking

I was trying to get the top 3 of my customers using the following measure:   Rankingmeasure = IF(NOT ISBLANK([_Measure1]) ,RANKX(ALLSELECTED('Customer Attributes'[Parent_co]), [_Measure1]))   An...
Need Help
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
3 years ago

Anonymous , Use TOPN

 

example

CALCULATE([measure],TOPN(5,all(Table[Project]),[Measure],DESC),VALUES(Table[Project]))

 

Learn Power BI: Dynamic TOPN using TOPN/Window and Numeric parameter: https://youtu.be/vm2mdEioQPQ

Anonymous's avatar
Anonymous
Not applicable
3 years ago

I know I can use TOPN. I'm trying to troubleshoot to deeper my understanding of DAX.