Matrix Total Missing

[cottrera]

Hi

I have a matrix visual in power bi  that uses the following 3 DAX functions.

Daily hours (mins)= SUM('Daily Contracted Minutes'[Daily Minutes Contracted]) // measure fed by Parameter

Total Activity Time (mins) = SUM('Operative Activity'[Total Time])

Time not utilised (mins) = IF([Total Activity Time] > [Daily hours] , BLANK(),
IF([Total Activity Time] = 0, BLANK(),
[Daily hours] - [Total Activity Time]))

Here is an example of the Matrix. However the totals for  Time not utilised (mins) is blank. However I need to keep the existing IF statement in the  Time not utilised (mins) measure .

	10 October 2022
Team	Operative Name	Daily hours	Total Activity Time	Time not utilised (mins)
Elec	Engineer A	510	411.5	98.5
Engineer B	510	472.4	37.6
Engineer C	510	522.8
Engineer D	510	471.0	39.0
Engineer E	510	344.5	165.5
Engineer F	510	470.8	39.2
Engineer G	510	324.7	185.4
Total	510	3017.6	?

thank you 
Richard

[cottrera]

Thank you Xiaoxin Sheng

For the link to a great article. This solved my Matrix issue. Better make sure I vote to Improve Matrix totals 😃 

[Anonymous · Accepted solution]

HI @cottrera,

This seems like a common issue measure expressions calculate on the total level which includes multiple levels of aggregations.

For this scenario, you can take a look at the following link to use summarize function aggregate on the detail level records, and use the iterator function to apply the second level aggregated to summary previous results:

Measure Totals, The Final Word 
Regards,

Xiaoxin Sheng