Decomposition Tree - Use Case

[surendar12]

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

[Anonymous]

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

[amitchandak]

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/

[surendar12]

@amitchandak  it is step2/step1 , step 3/ step 1, step4/step1

[amitchandak]

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]))