Forum Discussion
TOP 10 - Pie Chart
- 8 years ago
Hi A_Barny,
I created two new tables as your description. And take the following steps to meet your requirement.
If your tables are the same as the ones in pbix attached, you can have a try.1. Create connection between TableA and tableB based on the date columns. Create the YTD measure.
YTD = TOTALYTD(SUM(TableB[Quantity]),TableB[Date])
2. Create two calculated columns in TableA.
Rank = RANKX(ALL(TableA[Customers]),CALCULATE(SUM(TableB[Quantity]),ALLEXCEPT(TableA,TableA[Customers])))
top 10 = IF(TableA[Rank]<10, TableA[Customers], "Top Others")
Then we can get the result as below.For more details, please check the pbix as attached.
https://www.dropbox.com/s/bnaavh9mw9ck5qm/TOP%2010%20-%20Pie%20Chart-re.pbix?dl=0
If you still have questions, kindly share your PBIX file to me.
Regards,
Frank
Hi A_Barny,
I created two new tables as your description. And take the following steps to meet your requirement.
If your tables are the same as the ones in pbix attached, you can have a try.
1. Create connection between TableA and tableB based on the date columns. Create the YTD measure.
YTD = TOTALYTD(SUM(TableB[Quantity]),TableB[Date])
2. Create two calculated columns in TableA.
Rank = RANKX(ALL(TableA[Customers]),CALCULATE(SUM(TableB[Quantity]),ALLEXCEPT(TableA,TableA[Customers])))
top 10 = IF(TableA[Rank]<10, TableA[Customers], "Top Others")
Then we can get the result as below.
For more details, please check the pbix as attached.
https://www.dropbox.com/s/bnaavh9mw9ck5qm/TOP%2010%20-%20Pie%20Chart-re.pbix?dl=0
If you still have questions, kindly share your PBIX file to me.
Regards,
Frank
It' s work !
Thanks a lot,
Alex