Blank rows in matrix

[po]

Hi,

Have a matrix which shows o.k. until I put in a measure which compares this to previous week

2 levels in matrix

region which shows it o.k without blank rows and product which shows the balnk rows when tries to compare this to previous week.

When have a matrix which has multiple levels in it, is it possible to only show the value at ceratin level of matrxi such that when at second part of matrix wouldn't attamept to show it and thefore avoid the bakno rwos?

Dimension on left and as can see lost of dimensions with blank rows when put in 

[Anonymous]

@po  - See whether changing this setting will help.

[po · Accepted solution]

Thanks for reply - toggle this has no impact.

Had to use isfiltered saying if not isfiltered(attribute at that level in matrxi) then show the value

[ubilger]

Hi there. Can you by chance elaborate? 

[po]

Hi,

long time ago but this may help as used this to resolve.

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

Thanks