Forum Discussion
Dynamic Percentile Matrix
Greetings! I am trying to build a percentile matrix that allows the user to slice it by year, sales channel, business unit, category, sub-category, etc. Below is what I am trying to build in ...
Hi ALLUREAN
Thank you for providing me with this solution!
Are we able to achieve the same outcome without unpivoting the original fact table?
The reason being, is that I have a lot of other measures on top of that fact table and unpivoting would require me to re-write all the DAX code I have.
Go to matrix options, under Values should have Show on rows. Not sure this will solve it, depends on your data
But the measures you provided are dependent on the unpivoted table and not the original table. Am I missing something?