Forum Discussion
DAX Measure, Total is wrong
Hi, i actually had an error in my data. Thanks for your help anyways.
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:
Measure 2 (Adjusted for Total):
DAX
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
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])) )Hi, i actually had an error in my data. Thanks for your help anyways.