Choose a column using a parameter

[maserr]

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,

[Greg_Deckler]

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]

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