Forum Discussion
Calculating Measure Total using one measure In Matrix Drilldown
Hi, I found an amazing post Greg_Deckler solving the issue of measure total allows the "Total" to display the sum of the values in the column. Here is the link to his post: Measure Totals, Th...
amitchandak
Super User
Super UserAnonymous , do you want to subtract 50 in each line?
then you can try
Single Measure = sumX(Table1,Table1[Value]-50)
Unfortunately, it doesn't work.
I named the measure you suggested "Solution". However, that measure only calculates the Single Measure at the lowest level in the table.
When you at the Category1 level, which is the "smallest", it has the result I expect. But it stays the same when I switched to Category2 Level.