Calculated member depended on dimension value

[happymappy]

I have a dimension called MyDimension with attributes
- Model
- ModelValue

One of my measures called MyMeasure.

I need a calculated measure to calculate the value based on existing measure and dimension Model/ModelValue pair above.

In particularly,

case 
   when MyDimension.Model.MemberValue = "A" then [Measures].[MyMeasure] * [MyDimension].[ModelValue].MemberValue
   when MyDimension.Model.MemberValue = "B" then [Measures].[MyMeasure] * [MyDimension].[ModelValue].MemberValue / 100
   else Null
end

I could have this calculated, however, the totals aren't aggregated. Can someone help me?

Thanks

[ck9663]

If you need to aggregate all of it, you're going to need to use aggregate function, like COUNT(*) or SUM()

Happy Coding!!!

~~ CK

[happymappy]

Hi ck9663, I'm a newbe to ssas, could you be a bit more specific? i.e where should I make that sums? in Scope or another calculated member? The expectation is to drag any attributes of MyDimension and should be able to aggregate by all, thanks in advance

[ck9663]

I'm not familar with SSAS. Is this sql based? Post te entire T-SQL that you're having a problem with. We'll go from there.

Happy Coding!!!

~~ CK

[happymappy]

No, it's not T-SQL based it's mdx query

[ck9663]

Are you reading SQL Server table?

~~ CK