Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
joku50
Frequent Visitor

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 :

RegionCountry# of Commissioned project# of Proposals
AsiaKorea12
EuropeGermany03
AsiaThailand25
AsiaKorea34
EuropeFrance11
North AmericaCanada24
North AmericaCanada01

 

Desired outcome in Matrix visualization(PBI):

RegionCountrySum of commissioned projectSum of ProposalsCommissioning rate(%)
AsiaKorea4667%
EuropeGermany030%
AsiaThailand2540%
EuropeFrance11100%
North AmericaCanada2540%

 

 

 

1 ACCEPTED SOLUTION
Payeras_BI
Super User
Super User

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.

 

Payeras_BI_0-1625233662231.png

 

 

If this post answered your question, please mark it as a solution to help other users find useful content.
Kudos are another nice way to acknowledge those who tried to help you.

J. Payeras
Mallorca, Spain

View solution in original post

3 REPLIES 3
Payeras_BI
Super User
Super User

@joku50 

Happy to help!

 

If this post answered your question, please mark it as a solution to help other users find useful content.
Kudos are another nice way to acknowledge those who tried to help you.

J. Payeras
Mallorca, Spain
Payeras_BI
Super User
Super User

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.

 

Payeras_BI_0-1625233662231.png

 

 

If this post answered your question, please mark it as a solution to help other users find useful content.
Kudos are another nice way to acknowledge those who tried to help you.

J. Payeras
Mallorca, Spain

Hello!

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

Helpful resources

Announcements
Fabcon_Europe_Social_Bogo

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

Top Solution Authors
Top Kudoed Authors