Forum Discussion
Matrix Aggregation Issue
I am having troubles getting my totals to add correctly in my matrix. Here are my DAX measures: Expected Hours = IF([WH Affected] = 0 && [Worked Hours] = 0,0, SUM(L_Date[Expected Hours Worked]) * ...
I added a link to my data tables in the original post. I tried your solution and got the below:
Anonymous ,
Yes but that link does not contain all your tables to check your measures based on them.
How did you write the SUMX over SUMMARIZE? It should work.