Forum Discussion

maserr's avatar
maserr
Helper IV
6 years ago

Choose a column using a parameter

Dear all,

 

I have a difficult situation I am afraid I do not have a solution. I am creating a table in Report Builder that is using a SSAS tabular cube. The fact is that this report tries to be a general report that depending on several measures shows data. This data shown depends on the measure chosen so this measure (a column) would have to be selected dynamically depending on the parameter that has been decided.

 

Is there any way to do that? I cannot manually do it because I have nearly 300 measures and each one has several conditions.

I could put on my table all these measures but I would need to dynamically filter by one of this depending on the parameter.

 

Thanks in advance,

2 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion

    Not sure I am following 100% but perhaps you are trying to do something like this:

     

    Measure = 

      SWITCH([Some Measure],

        "Condition 1",[Measure 1],

        "Condition 2",[Measure 2],

        "Condition 3",[Measure 3],

        ....

      )

    • maserr's avatar
      maserr
      Helper IV

      Thanks Greg, yes I mean that but applied on the Query Desginer of my Data Set in Report Builder. Could this be possible?

       

      Thanks another time