Forum Discussion

Icon for Helper II rank

Helper II

6 years ago

Parent child aggregation DAX code not working

Hi Experts, I followed the link below to create my DAX code measure: https://community.powerbi.com/t5/Desktop/Summing-Aggregating-on-Parent-Child-Hierarchies/m-p/394500#M179959 In the exampl...

Icon for Most Valuable Professional rank

Most Valuable Professional

6 years ago

Hi amarsale85 ,

can you provide some sample data?
Are you using your star scheme?

amarsale85
Helper II
6 years ago
In the 1st post i had given all details of data which got lost as i got some error, same happened 2nd time. 3rd time i kept it short
Anyways here is my data,

DimLocation
LocationID Location Parent Location ID
1 North America NULL
2 USA 1
3 Florida 2
4 Miami 3
5 Fort Myers 3
6 Canada 1
7 Ontario 6
8 Toronto 7

DimAmountType
AmountTypeID Amount Type
1 Registration Fees
2 License Fees
3 Product Cost

FactAmount
FactKey LocationID AmountTypeID Amount
1 1 3 1000
2 2 1 250
3 4 2 150
4 5 2 100
5 6 3 1500
6 7 3 1200
7 8 1 300
8 8 2 200
- amitchandak
  Super User
  6 years ago
  amarsale85 , refer if these can help
  
  https://radacad.com/parsing-organizational-hierarchy-or-chart-of-accounts-in-power-bi-with-parent-child-functions-in-dax
  
  https://www.thebiccountant.com/2019/10/03/parent-child-hierarchies-with-multiple-parents-in-power-bi-with-power-query/
  - amarsale85
    Helper II
    6 years ago
    Thank you for the help but unfortunately this doesn't help me.
    I should be able to show data in chart as shown below:
    
    Here you can see, All Locations selected are from different levels, but are seen besides each other, that is no drill down.