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, The Final Word - Microsoft Power BI Community

But it seems he also suggests you have to create separate measures for different columns by saying: "Is it annoying to have to create multiple measures and specifically tailor them to each individual visual? Yes, yes it is."

Now, I am having trouble calculating the measure total at different levels of matrix drilldown using one measure. Here is my example.

This is the data set I used:

This is the single measure:

Single Measure = sum(Table1[Value])-50

 

These are the measures to calculate measure total for Catory1 and Category2:

 

Measure Total Category 1 = sumx(values(Table1[Category1]), [Single Measure])

 

Measure Total Category 2 = sumx(values(Table1[Category2]), [Single Measure])

 

As you can see, Measure Total Category 1 only shows total at Category 1 level of drilldown and Measure Total Category 2 only shows total at Category 2 level of drilldown.

 

 

 

 

 

 

Is there a way to create one measure showing category 1 total(3200) at category 1 drilldown and category 2 total(3500) at category 2 drilldown?

 

Regards,

Qisheng