I've just started working with SSAS Tabular model and i faced a big problem. I don't know how to create parameter that will switch dimensions in my table.
User gets drop down list (Category, Sub Category, Version etc.)
If he chooses Category - it will become the first column in table, if he chooses Version it will replace Category and etc
In normal mode (without Cube) it's quite easy - create calculated field and parameter.
What i've discovered after reading all topics is that in cubes I can't use dimensions in calculated field, second thing is that i can't use parameters in MDX...
So is there any way to switch dimensions dynamically in cube models?
Thanks in advance!
Become a Viz Whiz on the Forums!
Support the Community and master Tableau.
Retrieving data ...