Forum Discussion

leorrn's avatar
leorrn
Regular Visitor
3 years ago

Create Total by subgroup+ Difference + % using the new DAX function Window

Hello guys how are you?   Here is one example of my PBI (simple one, with sales by country per day)   I'm looking forward to (using the new DAX window function):  add a total by Continent...
Jihwan_Kim's avatar
Jihwan_Kim
Super User
3 years ago

Hi,

Please check the below picture and the attached pbix file, whether it works for you.

 

 

 

Sales: = 
SUM( Tabela1[Sales] )

 

Diff: = 
CALCULATE ( [Sales:], Tabela1[Group] = "Americas" )
    - CALCULATE ( [Sales:], Tabela1[Group] = "Europe" )

 

Percentage: = 
DIVIDE( [Diff:], CALCULATE([Sales:], Tabela1[Group] = "Americas"))