Forum Discussion

nbs333's avatar
nbs333
Frequent Visitor
4 years ago

Ragged Heirarchy issue using MAX function

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. 

2 Replies

  • AlexisOlson's avatar
    AlexisOlson
    Super User
    4 years ago

    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.

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    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.