Total for DAX measure does not work [SUMMARIZE function]

[JeroenZuidlaren]

Hello,

I have created a measure "UrenKosten_Test3"

The measure should summarize the total cost per "Code" based on:
- number of hours for a Code > this is capured in a measure "WBSOGeschrevenTMMaand"
- Uurtarief, ForfaitI, ForfaitII, these are in a budget Table and used as a variable in this measure.

In the visual table the calculation on Code level is correct.

However the total is incorrect. It seems it is calculated based on the Minimum of all Uurtarief [21] and all Forfaits [10].

(21+10=31) x 4.253 = 131.843

However the total should be the sum of the individual codes:

30.021 + 19.096 + 49.256 + 30.888 = 129.261

I thought this is exactly what is summarize in the _table and with a SUMX this should be the total result.

What do I miss?

[Greg_Deckler]

@JeroenZuidlaren First, please vote for this idea: https://ideas.powerbi.com/ideas/idea/?ideaid=082203f1-594f-4ba7-ac87-bb91096c742e

This looks like a measure totals problem. Very common. See my post about it here: https://community.powerbi.com/t5/DAX-Commands-and-Tips/Dealing-with-Measure-Totals/td-p/63376

Also, this Quick Measure, Measure Totals, The Final Word should get you what you need:
https://community.powerbi.com/t5/Quick-Measures-Gallery/Measure-Totals-The-Final-Word/m-p/547907

Also: https://youtu.be/uXRriTN0cfY
And: https://youtu.be/n4TYhF2ARe8

[JeroenZuidlaren]

Thanks a lot @Greg_Deckler ! I have voted for the idea.

I also studied the links but it seems it is not the "classic" issue.

The point in my DAX statement is that for the total row the statement is looking to var T1 & T2 as the minimum values of everything in the budget table.
However it should calculate in the IF statement with the minimum values per code. 

In the table it is doing this because the Code is in the Row context.

For the total there is no context.

I was expecting because I build the _table that it was picking per code the minumum values T1 & T2 and calculates the outcomes with that. Then I just need to SumX the total.

However this does not work...

thanks again.
Jeroen

[Greg_Deckler]

@JeroenZuidlaren Going to need sample data. Sorry, having trouble following, can you post sample data as text and expected output?
Not really enough information to go on, please first check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882

Also, please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.

[JeroenZuidlaren · Accepted solution]

Hello @Greg_Deckler . I have solved this issue.

The T1 and T2 need to be part of the IF statement. Only then it is summarizing correctly per Code.

I have another issue with this dataset but will prepare sample data tomorrow and mention that over here or start a new post. Thanks!