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

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
Anonymous
Not applicable

Calculate percent of Total for two dimension columns

Hi,

I would like to show a percent of "Total Global" and "Total By Group" in the same column like this example. Is it possible?

(p.s: the last column was manually drawn, I would like to create a measure that make this result possible)

 

The idea is: 

1) Calculate the percent of group´s rows using the Total Sales / Total Global

2) Calculate the percent of country´s rows using the Total Sales / Total by Group 

 

I´m using the AdventureWorks' dataset

1 ACCEPTED SOLUTION
Ashish_Mathur
Super User
Super User

Hi,

Try this measure

=IF(HASONEVALUE(Data[Country]),[Total Sales]/[Total by Group],[Total Sales]/[Total Global])

Hope this helps.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

View solution in original post

4 REPLIES 4
Ashish_Mathur
Super User
Super User

Hi,

Try this measure

=IF(HASONEVALUE(Data[Country]),[Total Sales]/[Total by Group],[Total Sales]/[Total Global])

Hope this helps.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/
Anonymous
Not applicable

Thank you a lot @Ashish_Mathur 


It´s worked perfectly. I don´t believe.

You are welcome.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/
mauriciosotero
Resolver III
Resolver III

Hi,

 

Why you just use the

 

Measure = DIVIDE([Total Sales],[Total Global])

It will works for the 2 cases.

 

If this helps, I apreciate you give a kudo and mark as the solution. Thanks

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors