Forum Discussion
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 drill down it should reflect the data against those top , not the top values against the clicking option.
Example,..
* It should display data only for Top N client using Ranking
* But , in ranking at 1 level drill displays the Top N clients
*The lowest level, that is clicking on Proposal column it should leads only to the corresponding client in Top N, but it displays Top N of Proposal
* The Top N Ranking is not working for low level drill down
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.
1 Reply
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.