Forum Discussion
Decomposition tree
Hi
I am trying to do a decomposition tree but the hierarchy must be measure based and not dimension based.
I need the layout to look like the screenshot below:
As you can see it is replicating the first measure sales growth right through.
i created a table to separate to try and create a hierarch. Column 1 contains Sales Growth, Column 2 contains Growth and S, Column 3 counts U and P.
This is the measure Im using
SWITCH(
true(),
SELECTEDVALUE('Hierarchy'[Column1])="Sales Growth",sg,
SELECTEDVALUE('Hierarchy'[Column2])="Growth",tg,
SELECTEDVALUE('Hierarchy'[Column2])="S",spt,
SELECTEDVALUE('Hierarchy'[Column3])="U",upt,
SELECTEDVALUE('Hierarchy'[Column3])="Ph",usp)
Help resolving this will be much appreciated.
Help resolving this will be much appreciated.
1 Reply
Decomposition trees only support a single measure as the basis. All other fields must be columns.
