Forum Discussion
Parent child aggregation DAX code not working
Hi Experts,
I followed the link below to create my DAX code measure:
In the example given in link, the code will only work with "Company" attribute but if i add attributes from another dimensions say Location, SalesType, etc., this DAX code won't work. So what change i need to do in the DAX code for it work with attributes in dimensions?
Please help.
7 Replies
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
