Ragged Heirarchy issue using MAX function

[nbs333]

Hi,

I am using Daxpattern's guide to remove blanks from my ragged heirarchy. (https://www.daxpatterns.com/parent-child-hierarchies/)

I've followed it exactly but am runninng into an issue. The MAX function below returns blank values for some of my clients. I have verified in my data table that all rows have a value of one or greater for the column 'Entity[Depth]'.

EntityRowDepth := MAX ( Entity[Depth] )

When I add this measure below to my final matrix, these customers don't show because EntityRowDepth is blank.

Total Base :=
VAR Val = [Sum Amount]
VAR EntityShowRow =
    [EntityBrowseDepth] <= [EntityRowDepth]
VAR Result =
    IF ( EntityShowRow, Val )
RETURN
    Result

Any idea what is causing this? Unfortunity I can't share my file but I hope this is enough to explain the situation. 

[Anonymous]

Hi @nbs333 ,

Please provide some data and expected output.

Best Regards

Community Support Team _ polly

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

[AlexisOlson]

Can you share a link to a file that demonstrates the issue? It can be simple dummy data, not any real data.

It's very difficult to diagnose this sort of thing completely in the dark.