topic DAX Measure, Total is wrong in DAX Commands and Tips

DAX Measure, Total is wrong

LuITS — Mon, 13 Jan 2025 11:12:57 GMT

Hello I have problems converting formulas into DAX measure,

Measure 1:
SUM(Quantity) / SUM( Quantitiy / Goal )

My try:

DIVIDE('Table'[Quantity], SUMX('Table', DIVIDE('Table'[Quantity], 'Table'[Goal])))

Measure 2:
Other Measure / Measure 1

My try:

DIVIDE('Table'[Other Measure], 'Table'[Measure 1])

Problem is, that Calculations in Table Visual are right, but Total of Measure 2 is not correct. Measure 2 is displayed in %.

Output:

Quantity	Goal	Measure 1	Other Measure	Measure 2
158	2.400	2.400	4.277	178,2 %
1.734	3.300	3.300	2.857	86,6 %
564	2.650	2.650	2.093	79,0 %
130	2.400	2.400	1.910	79,6 %
Total 2.586			2.635	88,4%

All values are correct, but total of Measure 2 is off and should be 87,5%

can u help?

Re: DAX Measure, Total is wrong

FarhanJeelani — Mon, 13 Jan 2025 12:10:15 GMT

The issue with the incorrect total for your Measure 2 lies in how Power BI calculates totals for measures. By default, Power BI aggregates the row-level results, which can lead to discrepancies when the logic of the measure depends on row-level context. Instead, you need to adjust the logic of the measure to calculate the total correctly.

For Measure 2, instead of summing the row-level results, we should calculate the overall total using the same logic applied at the row level.

Measure 1:

DAX

Measure 1 =

DIVIDE( SUM('Table'[Quantity]), SUMX('Table', DIVIDE('Table'[Quantity], 'Table'[Goal])) )

Measure 2 (Adjusted for Total):

DAX

Measure 2 =

DIVIDE( SUM('Table'[Other Measure]), SUMX('Table', DIVIDE('Table'[Quantity], 'Table'[Goal])) )

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.

Re: DAX Measure, Total is wrong

rohit1991 — Tue, 29 Jul 2025 09:02:02 GMT

Corrected DAX:

Measure 1: Measure 1 = DIVIDE(SUM('Table'[Quantity]), SUMX('Table', DIVIDE('Table'[Quantity], 'Table'[Goal]))
Measure 2 (Fix Total): Use SUMX to correctly calculate the total: Measure 2 = VAR TotalQuantity = SUM('Table'[Quantity]) VAR TotalOtherMeasure = SUM('Table'[Other Measure]) VAR TotalMeasure1 = DIVIDE(TotalQuantity, SUMX('Table', DIVIDE('Table'[Quantity], 'Table'[Goal])))
RETURN DIVIDE(TotalOtherMeasure, TotalMeasure1)
This ensures the total recalculates correctly as 87.5%.

Re: DAX Measure, Total is wrong

LuITS — Mon, 13 Jan 2025 12:46:52 GMT

Hi, thanks for youre reply but i get error.

When i try to use Measure 2 i get following Error:
Collumn Other Meassure not found or cant be used in this expression.

DAX of Other Meassure: DIVIDE(SUM('Table'[Quantity], SUM('Table'[Time])) * 60

Re: DAX Measure, Total is wrong

FarhanJeelani — Mon, 13 Jan 2025 12:52:12 GMT

Use below:

Other Measure:

Other Measure = DIVIDE(SUM('Table'[Quantity]) + SUM('Table'[Time]), 1) * 60

Measure 2:

Measure 2 = DIVIDE(

[Other Measure], SUMX('Table', DIVIDE('Table'[Quantity], 'Table'[Goal])) )

Re: DAX Measure, Total is wrong

LuITS — Mon, 13 Jan 2025 16:02:31 GMT

Hi, i actually had an error in my data. Thanks for your help anyways.

Re: DAX Measure, Total is wrong

LuITS — Mon, 13 Jan 2025 16:02:43 GMT

Hi, i actually had an error in my data. Thanks for your help anyways.