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
- Mute
- 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

Highlighted

---------------------------------------

*Putting square pegs in round holes since 1972.*

##### I have a NEW book!

DAX Cookbook from Packt

Over 120 DAX Recipes!

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

Greg_Deckler

Super User IV

- Mark as New
- Bookmark
- Subscribe
- Mute
- 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.

---------------------------------------

DAX Cookbook from Packt

Proud to be a Super User!

2 REPLIES 2

Highlighted

---------------------------------------

*Putting square pegs in round holes since 1972.*

##### I have a NEW book!

DAX Cookbook from Packt

Over 120 DAX Recipes!

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

Greg_Deckler

Super User IV

- Mark as New
- Bookmark
- Subscribe
- Mute
- 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.

---------------------------------------

DAX Cookbook from Packt

Proud to be a Super User!

Highlighted
##

TSH

Frequent Visitor

Re: Show measure total ignoring columns in matrix

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

06-17-2019
06:29 AM

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 🙂

Announcements

Visit our Community Blog for articles, guides, and information created by fellow community members.

Need help with the Power BI Community? Our 'Using the Community' support articles are a great place to start.

Top Solution Authors

User | Count |
---|---|

314 | |

194 | |

114 | |

66 | |

62 |

Top Kudoed Authors

User | Count |
---|---|

362 | |

274 | |

146 | |

79 | |

75 |