Show items with no data only for first hierarchy row level

[Anonymous]

Hi,

Can't seem to find a good solution to this problem. I have a matrix with three levels of rows. For my test I have called it level1, level2 and level3. 

These can be found from two different dimension tables. What I'm curious about is if it is possible to show all level1 items, event when there is no data with related values to it?

I have tried to use the "Show items with no data" function, but this gives me all rows for every hierarchy level, which I do not want. 

To better show my issue I'm adding two pictures of my model and my matrix tables, one that includes all my level1 items, but noe values, which is how all are included, then I add level3 items and corresponding value, then some level1 items dissapear naturally because they are empty. 

Any suggestions on how to include all level1 items?

I have attached my sample file here: https://www.udrop.com/5yhX/showfirsthierarchy.pbix

Thanks!

[AlexisOlson · Accepted solution]

One possible workaround is to force level 1 to be non-blank by adding zero at that level.

SumVal = SUM ( 'Fact'[Value] ) + IF ( ISINSCOPE ( dim2[level2] ), BLANK(), 0 )

This means that if we are at level 2 (or below), then we keep it blank but use zero for the higher levels (level 1).

If you don't like the zeros instead of blank, you can change the measure display format to show nothing or something else for a zero result.