Applying different weights on each level of hierarchy
Hello, I have PnL fact table like this: fact_table([id],[date],[account_key],[sales_amount]) and dimension for PnL hierarchy like this: dimension_table([account_key],[level_1_name],[level_2_name],[level_2_weight],[level_3_name],[level_3_weight],[level_4_name],[level_4_weight],[level_5_name],[level_5_weight]) relationship between those table is M:N through account_key. I need to calculate sum of sales_amount with applying the correct weight when going from a lower level of the hierarchy to a higher one. Not all levels for each account is valid -> each level except one can be null. I tried everything with INSCOPE, RELATED, SWITCH and SUMX but nothing worked for me. Link to the file here: PBIX I would very much appreciate any help. Thank you very much in advance.