Measure Subtotals in Matrix not working for both Rows and Columns

hi Anonymous ,

The Total calculation does precisely what you asked it to do, namely calculate the average for the day.

What you actually want to see, if I am not mistaken, is the sum of the hourly averages. In order to calculate this you need to calculate the hourly values again and then sum them into the required total.

Something like (depends also in the relations present): 

SUMX( 
summarize('table2',
table2[Channel],
table1[Hour],
"Monthly AVG",monthlyAverages
),
[Monthly AVG])

replace sumx(AverageTotal,[Monthly AVG]) with the above code snippet

Jan 

if this is a solution for you, don't forget to mark it as such. thanks