Percentage calculation using subtotals

[joku50]

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%

[Payeras_BI]

@joku50 

Happy to help!

[Payeras_BI · Accepted solution]

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.

[joku50]

Hello!

Thanks a lot, very simple indeed! It works perfectly.