Show measure total ignoring columns in matrix

[Fapo]

Hello community, I have a question.

I have a matrix constructed in the following way:

Value x: product stock

Columns: months

Rows: product description

This is fine. It shows the value for each month by product. At the end, it shows the column totals.

Now I want to add a second value (a measure), call it "value y", but:

I want only the column totals to be shown. I do not want to see the value for each month.

So it should be:

                Month 1 Month 2 Month 3 Total x  Total y

Product 1 Value x   Value x   Value x    Sum x     Sum y

Product 2 Value x   Value x   Value x    Sum x     Sum y

Product 3 Value x   Value x   Value x    Sum x     Sum y

And not:

                Month 1 Month 1 Month 2 Month 2 Month 3 Month 3 Total x  Total y

Product 1 Value x   Value y     Value x   Value y     Value x    Value y     Sum x     Sum y

Product 2 Value x   Value y     Value x   Value y     Value x    Value y     Sum x     Sum y

Product 3 Value x   Value y     Value x   Value y     Value x    Value y     Sum x     Sum y

So, is there a way to tell dax to ignore the month column filter?

Prima facie I actually don´t think there is one, but I want to be shure.

Cheers, and thank you very much in advance.

[Greg_Deckler · Accepted solution]

If you come up with a better way, let me know but what I had to do was write the measure so that if it was in a total row, it returned the value but otherwise returned BLANK(). But then I had to turn off word wrap and shrink all of the columns for that measure value. Ugly but works.

[TSH]

@Greg_Deckler 

How did you write the measure that checks if it is in a total row? Perhaps an ugly solution indeed, but if this trick works, it solves quite some problems 🙂