Forum Discussion

Badger43's avatar
Badger43
Frequent Visitor
3 years ago

DAX SUMX Multiple Hierarchy Level Query

Hi I am trying to return values from a 'Rates' table linked to the below 'MU' table on the Parent dimension (one MU to Many Rates)   I am using the formula SUMX( VALUES ( MU[Parent] ) ,[Allocation ...
Need Help
Badger43's avatar
Badger43
Frequent Visitor
3 years ago

lbendlin thanks very much for your reply and sorry I wasn't clearer.  I was anonymising and simplifying the full model and only got so far in the time I had.  I have reloaded the file with full renaming, and also update the formulas in my original post to take account of this.

 

In the MU 'Parent' column there are no gaps, but in some instances (for the RBU2 Series of the rates table) there is no corresponding value in the rates table.  At this point I would like it to use the values which would be linked on the MU'Dept' column instead.

 

Hope this makes things clearer and again a solution for this would be much appreciated.

 

Thanks again

Mark

  • lbendlin's avatar
    lbendlin
    Super User
    3 years ago
    In the MU 'Parent' column there are no gaps, but in some instances (for the RBU2 Series of the rates table) there is no corresponding value in the rates table.

    You lost me. I cannot see where the gaps are.