Forum Discussion
Percentage calculation using subtotals
Hello,
I am a newbie here trying to set up my first dashboard for the business.
Have been searching for days for a tip here to create measures/columns properly using DAX.
I also would like the Numerators/Denominators to keep changing just like subtotals by the end-user selections made to the filters.
Could you please help to let me know how I can visualize the commissioning rate/summary counts in the example below?
Raw data file looks like :
| Region | Country | # of Commissioned project | # of Proposals |
| Asia | Korea | 1 | 2 |
| Europe | Germany | 0 | 3 |
| Asia | Thailand | 2 | 5 |
| Asia | Korea | 3 | 4 |
| Europe | France | 1 | 1 |
| North America | Canada | 2 | 4 |
| North America | Canada | 0 | 1 |
Desired outcome in Matrix visualization(PBI):
| Region | Country | Sum of commissioned project | Sum of Proposals | Commissioning rate(%) |
| Asia | Korea | 4 | 6 | 67% |
| Europe | Germany | 0 | 3 | 0% |
| Asia | Thailand | 2 | 5 | 40% |
| Europe | France | 1 | 1 | 100% |
| North America | Canada | 2 | 5 | 40% |
Hi joku50 ,
If I understood correctly you only need to place the two SUM and % measure in a Table visualization in PBI Desktop to get the desired outcome.
3 Replies
Hi joku50 ,
If I understood correctly you only need to place the two SUM and % measure in a Table visualization in PBI Desktop to get the desired outcome.
Hello!
Thanks a lot, very simple indeed! It works perfectly.
