Calculate the sum of the individual grouped values

Anonymous — Tue, 08 Jun 2021 11:58:37 GMT

Hi,

I created a measure that calculates a certain number. This is the measure:

--------------------

VAR =

VAR ActualsTotal = CALCULATE([Sum of Sales], ALLSELECTED(TABLE))

VAR ActualsPercTotal = DIVIDE([Sum of Sales], ActualsTotal)

VAR BudgetTotal = CALCULATE([Sum of Budget], ALLSELECTED(TABLE))

VAR BudgetPercTotal = DIVIDE([Sum of Budget], BudgetTotal)

VAR Margin = [Margin % Budget]

VAR MarginTotal = CALCULATE([Margin % Budget], ALLSELECTED(TABLE))

RETURN

(ActualsPercTotal - BudgetPercTotal) * (Margin - MarginTotal)

--------------------

When I create a crosstab or table with a column "Category" and the measure, this is the result:

CATEGORY VAR

Car 0.1

Bike 1.4

Bus -0.5

----------------

Total 0.0

These numbers are correct. But I would like the total to be the sum of the 3 rows. In this example the total is 0, which is result of the measure when no category is used. The result I would like to have is 1.0 (the sum of 0.1, 1.4 and -0.5)

Does anyone know how to create a formula that does the same but adds up the individual grouped values?

Re: Calculate the sum of the individual grouped values

Anonymous — Tue, 08 Jun 2021 13:03:35 GMT

You can start here: (3) Dax for Power BI: Fixing Incorrect Measure Totals - YouTube

topic Calculate the sum of the individual grouped values in DAX Commands and Tips

Calculate the sum of the individual grouped values

Re: Calculate the sum of the individual grouped values