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.)? I need it to show 10 USD or whatever the actual total is. I was thinking that I might need a formula for it but I wouldn't know to build it, since there are other categories as well - Won, Lost, and Pending, and for each, I need the total summed amount of coupons.

Thanks a lot!

 



Data Protection
Need Help
Tutorial Requests

1 Reply

  • 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?