topic Ragged Heirarchy issue using MAX function in DAX Commands and Tips

Ragged Heirarchy issue using MAX function

nbs333 — Sun, 14 Nov 2021 14:32:13 GMT

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.

Re: Ragged Heirarchy issue using MAX function

AlexisOlson — Sun, 14 Nov 2021 18:02:38 GMT

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.

Re: Ragged Heirarchy issue using MAX function

Anonymous — Wed, 17 Nov 2021 02:53:59 GMT

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.