1 Reply Latest reply on Mar 15, 2019 6:05 PM by Ajai Govind

    SSAS Tabular model - Top n, swtiching dimensions with parameter

    Jacek M

      Hi guys,

       

      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.

      Example:

      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!