- Forums
- Get Help with Power BI
- Desktop
- Service
- Report Server
- Integrations with Files and Services
- Mobile Apps
- Developer
- DAX Commands and Tips
- Let's Talk Data
- Custom Visuals Development Discussion
- Community Support
- Welcome to the Community
- Community Feedback
- Community Help Blog
- Training and Consulting
- Dashboard in a Day
- EdX Specific Training Discussion Forum

Turn on suggestions

Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.

Showing results for

- Microsoft Power BI Community
- Forums
- Get Help with Power BI
- Desktop
- Show measure total ignoring columns in matrix

Topic Options

- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page

Highlighted

Fapo

Frequent Visitor

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

11-15-2018
09:13 AM

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.

Solved! Go to Solution.

1 ACCEPTED SOLUTION

Accepted Solutions

Greg_Deckler

Super User

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

11-15-2018
10:08 AM

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.

Proud to be a Datanaut!

1 REPLY 1

Greg_Deckler

Super User

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

11-15-2018
10:08 AM

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.

Proud to be a Datanaut!