Calculate percent of Total for two dimension columns

[Anonymous]

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

[Ashish_Mathur · Accepted solution]

Hi,

Try this measure

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

Hope this helps.

[Anonymous]

Thank you a lot @Ashish_Mathur 

---

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

[Ashish_Mathur]

You are welcome.

[mauriciosotero]

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