cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Fapo Frequent Visitor
Frequent Visitor

Show measure total ignoring columns in matrix

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.

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: Show measure total ignoring columns in matrix

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.


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!


1 REPLY 1
Super User
Super User

Re: Show measure total ignoring columns in matrix

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.


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!