Forum Discussion

Uma_Dhandpani's avatar
Uma_Dhandpani
Icon for Helper I rankHelper I
6 years ago
Solved

Top N Selection and Ranking vs Drill down

                    Hi, I need help in Top N Selection using drill down. The Condition is that when dynamic clicking on Top N it leads to Top clients , when further clicking on d...
Need Help
  • v-xicai's avatar
    v-xicai
    6 years ago

    Hi Uma_Dhandpani ,

     

    Assuming the column which contains "Proposed", "Actual", "Invoice" is named "column1", and the column which has been dragged into Values box of Matrix visual is named "Value", you may create columns in table Table2 like DAX below.

     

    Top N Rank = RANKX(FILTER(Table2, Table2[column1]=EARLIER(Table2[column1])),Table2[Value],,DESC ,Skip)

     

    Then you can put the new column [Top N Rank] into Visual level filter of Matrix visual, set its values to "less than or equal to N", the N may be 1,2,3 or other values.

     

    If I misunderstood it, could you please share your sample data and desired output screenshots for further analysis? You can also upload sample pbix to OneDrive and post the link here. Do mask sensitive data before uploading.

     

    Best Regards,

    Amy

     

    Community Support Team _ Amy

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-xicai's avatar
v-xicai
Icon for Community Support rankCommunity Support
6 years ago

Hi Uma_Dhandpani ,

 

Assuming the column which contains "Proposed", "Actual", "Invoice" is named "column1", and the column which has been dragged into Values box of Matrix visual is named "Value", you may create columns in table Table2 like DAX below.

 

Top N Rank = RANKX(FILTER(Table2, Table2[column1]=EARLIER(Table2[column1])),Table2[Value],,DESC ,Skip)

 

Then you can put the new column [Top N Rank] into Visual level filter of Matrix visual, set its values to "less than or equal to N", the N may be 1,2,3 or other values.

 

If I misunderstood it, could you please share your sample data and desired output screenshots for further analysis? You can also upload sample pbix to OneDrive and post the link here. Do mask sensitive data before uploading.

 

Best Regards,

Amy

 

Community Support Team _ Amy

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.