November 20, 2016 at 10:01 pm
Hello
I am trying to create a formula in Calculated measure
Dimension Cell has multiple members including Control and Core. There is one more dimension called Data. I also have measure called [Measures].[Rate] which is precalculated as percentage
I need to achieve below formula
([Measures].[Rate] in [Cell].[ABC].&[Control] and [Cell].[ABC].&[Core] also in [Data].[PQR].&[Yes])
or
SUM (
{ [Cell].[ABC].&[Control] , [Cell].[ABC].&[Core] }
,{[Data].[PQR].&[Yes])}
,[Measures].[A]
)
As SUM or AGGREGATE takes two value only how to achieve above
------------------------------------------------------------------------------------
Ashish
November 21, 2016 at 6:28 am
While I don't have any direct experience with SSAS, I do have some conceptual knowledge, and you didn't mention whether or not the Cell dimension has any relationship to the Data dimension. You also didn't specifically state what you have tried, or any error messages you may have received. What little I do know suggests you may need to somehow relate the two dimensions in some fashion, but I'm wide open to new knowledge, so if there's better information out there, please correct me...
Steve (aka sgmunson) 🙂 🙂 🙂
Rent Servers for Income (picks and shovels strategy)
November 21, 2016 at 9:31 pm
Got the answer
It should be as below
SUM (
{ [Cell].[ABC].&[Control] , [Cell].[ABC].&[Core] }*{[Data].[PQR].&[Yes])}
,[Measures].[A]
)
------------------------------------------------------------------------------------
Ashish
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply