Forum Discussion

atul9063's avatar
atul9063
Helper III
7 years ago
Solved

Calculated Member based on dimension attribute value

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

Show and Tell
  • Anonymous's avatar
    Anonymous
    7 years ago

    atul9063,

    Create the following measure in your table.

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



    Regards,
    Lydia

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    atul9063,

    Create the following measure in your table.

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



    Regards,
    Lydia