Calculated Member based on dimension attribute value

[atul9063]

I have a report that is using a ssas multidimensional cube as data source (live connection)

I have two amount measures (local_amount and euro_amount)


I have created role dimension metric attribute (Index,MetricName)

Metric

Index  MetricNAme
1       IMT
2       UST

I want to create calculate measure in SSAS , when i select MetricName="IMT" then local_amount  measure should select else  euro _amount would select.

Please help me on this task

[Anonymous · Accepted solution]

@atul9063,

Create the following measure in your table.

Measure= IF (
      ISFILTERED (Metric[MetricName] )
        && VALUES ( Metric[MetricName]) = "IMT"
       ,
   [local amount],
 [euro-amount]
)

Regards,
Lydia