Matrix hierarchy header's columnar values-want to hide

[Vauban]

Hi to all.  I'm really hoping this is a dumb question and easily answered.

Also, as I re-read my story below I've tried to be as excessively clear and probably too wordy.  Just wanted to be understood.  🙂

I have a matrix with date hierarchy.  There are nine columns of grid data.

The grid data shows fine at the lowest level but when I roll up the rows to each hierarchy group I still get grid values.

These row header grid values don't make sense and I want them not to show.

The screen shot says this better.

Example: the lowest level is showing with two rows of data - Jan 17 items 001 and 002.

The nine votes for each of those motions is showing correctly.

But in the top half of the screen shot you can see that I have rolled up the hierarchy so it just shows one line for each date.

Nevertheless, it still shows column values.

These aren't subtotals so, to my knowledge, subtotal commands don't make them disappear.

I don't want to see these values that are in rows Nov 8 and Nov 22.

When I roll up all of November then I end up seeing rows for November and so on.

How do you get Power BI to not show grid values for rollup headers?

Any and all help is greatfully appreciated.

[ChrisMendoza]

@Vauban -

Have you tried something like what the folks over at https://www.sqlbi.com/articles/clever-hierarchy-handling-in-dax/ suggest? I think what you should be shooting for though is asking whether or not the 'heirarchy level should be shown'. Something like ISFILTERED('Calendar'[Day]).

Reference - https://docs.microsoft.com/en-us/dax/isfiltered-function-dax

[Vauban]

Hi Chris.  Honest thanks for those thoughts.  I'm setting this report to just run on a desktop though.  I looked at the isfiltered dax page link you sent and it looked great but is that just for server run efforts?   I've made measures and such but I've never tried to write dax to a desktop matrix before.  I'm probably thinking it's possibly at the desktop level when it is not.  I've googled around trying to read up on this quickly but am missing it.  David

[ChrisMendoza · Accepted solution]

@Vauban -

You use it within your Measure something like pseudo:

IF(
  ISFILTERED(),
  SUM(),
  BLANK()
)

[Vauban]

Thank you Chris.

David