Total row wrong

[Ronning]

Hi i have a problem with the total row in the column "TEST" as you can see the total row shows the last rows value not the summed total as i want. 

TEST = CALCULATE([Revenue Skidata]

     , FILTER(ALL(Dim_Date_TransactionDate) , Dim_Date_TransactionDate[YearWeekNr] = MAX(Dim_Date_TransactionDate[YearWeekNr]) -100 ))

Thanks

[ibarrau · Accepted solution]

Hi. The engine is working perfectly. Totals in Power Bi are not the sum of whatever is in the table. They are running the same measure at a different aggregation level. Your measure is just aggregating by MAX. So totals will use MAX.

In order to make it SUM you can do a second measure using this one that will iterate the results.

Check this post out that explains how to fix totals for similar scenarios: https://blog.ladataweb.com.ar/post/636304907248467968/dax-corrigiendo-el-total-de-una-medida

I hope that helps,