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 attr...
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

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