Forum Discussion
SSAS Multidimensional dimension attribute Calculated Members not showing up
So I recreated this problem using Adventureworks. I need to filter data based on customers who have had sales in last month, but not in 11 months before the last month. Calculated Member is defined as this:
REATE MEMBER CURRENTCUBE.[Customer].[Customer].[All Customers].[test]
AS IIF
(
[Date].[Month Name].CurrentMember IS [Date].[Month Name].[All Periods]
,null
,Aggregate
(
Except
(
NonEmpty
(
[Customer].[Customer].[Customer]
,(
[Date].[Month Name].CurrentMember
,[Measures].[Internet Sales Amount]
)
)
,NonEmpty
(
[Customer].[Customer].[Customer]
,
{
[Date].[Month Name].CurrentMember.Lag(12)
:
[Date].[Month Name].CurrentMember.Lag(1)
}
*
[Measures].[Internet Sales Amount]
)
)
,[Measures].CurrentMember*1000
)
),
VISIBLE = 1 ;
In Excel in is visible, in PowerBI it is not visible. If I delete all other attributes from the Customer dimension and leave only "customer" key attribute in place, calculated member then shows up in PowerBI. A bug?
v-sihou-msft an idea?