Forum Discussion
Decomposition Tree - Use Case
Hi All,
Decomposition tree is powerful and I have a use case that I would like to use for the repot.
What I have is a classic funnel and I would like to use as tree . Reason is because there are multiple paths inside a funnel.
Eventhough eveything seems to be working fine but the numbers are not correct because it is summing percentage by steps.
How to format my raw data to show the right percentage and build the tree
4 Replies
Please share the formula. I think we need to use isfiltered or hasonsvalue to suit to this requirement
https://powerpivotpro.com/2013/03/hasonevalue-vs-isfiltered-vs-hasonefilter/
Not clear but something like this
step 1 =calculate(countrows(Table1),allexcept(table1,table[path1]))
only step 2 =calculate(countrows(Table1))Ratio = calculate([only step 2 ]/step 1)
step 2 =calculate(countrows(Table1),allexcept(table1,table[path2]))
HI surendar12,
I think it should more relate to your formula, please share your formula that uses on the decomposition visal value field.
How to Get Your Question Answered Quickly
In addition, you can also take a look at the following blog to modify your formula to let it work on the total level:
Measure Totals, The Final Word
Regards,
Xiaoxin Sheng
