Calculated Member based on dimension attribute value

• selpoivre

  Say Hey Kid

  Points: 702

  More actions

  October 10, 2018 at 8:00 am

  #366222

  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