Forum Discussion

ksab23's avatar
ksab23
Icon for Helper I rankHelper I
3 years ago

Decomposition tree totals

Hi all, any advice on whether I can make the last column of my decomposition tree show total value instead of breaking it down to categories (3 kids won 0 USD coupons, 1 kid won 0.45 USD coupon, etc....
data protection
Need Help
Tutorial Requests
MFelix's avatar
MFelix
Icon for Super User rankSuper User
3 years ago

Hi ksab23 

 

This can be done using a dax measure but that would show the same value in all of the values (in this case 3) also be aware that you cannot control if the calculation is on the last level of the tree, meaning that if the category you use for that specific calculation is put on the second place of the tree you will get the 10 on the second place not on the last one.

 

Another question that I have is do you want to still have the split or do you want to have a single valuefor that specific column of the tree?