Blank Rows - Hierarchy matrix table

[Anonymous]

I was able to create an hierarchy following this guide: Parent-child hierarchies – DAX Patterns

Please see the image below:

What happens here is that the Parent shows the accumulated values. Which is exactly what i want. BUT in some cases

the parent also has values.

Thus power Bi creates an blank row with its values.

This is the code ive got - that creates the level.

Level1 = 

VAR LevelNumber = 1

VAR LevelKey = PATHITEM ( stats[path], LevelNumber, INTEGER )

VAR LevelName = LOOKUPVALUE ( stats[name], Stats[ID], LevelKey )

VAR Result = LevelName

RETURN

 Result

Ive tried to create some sort of IF statement - but did not succeed as im not familiar with DAX.

[v-yalanwu-msft]

Hi, @Anonymous ;

Is your problem solved?? If so, Would you mind accept the helpful replies as solutions? Then we could close the thread. More people who have the same requirement will find the solution quickly and benefit here. Thank you.

Best Regards,

Community Support Team_ Yalan Wu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[v-yalanwu-msft]

Hi， @Anonymous ；

I am not very clear about your collective needs. I have carefully checked your link and created a simple case. If you use the parent-child structure, you can directly use the matrix;

Maybe you can correct my understanding, you can share a simple example and hopefully the output?

Looking forwarding to your reply!

Best Regards,
Community Support Team_ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@Anonymous , I think you should use isinscope

https://www.kasperonbi.com/use-isinscope-to-get-the-right-hierarchy-level-in-dax/

You can check value and isinscope