Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi,
I'm trying to display dimension calculated members created in SSAS MD.
As stated here:
It works fine when the dimension has a single attribute.
I can't make it work when the dimension has more than one attribute.
For example, this member added to the AdventureWorks cube does not display in PBI:
CREATE MEMBER CURRENTCUBE.[Date].[Month of Year].[LastDate]
AS TAIL(
NONEMPTY(
[Date].[Date].[Date]
,[Measures].[Sales Amount]
)
,1
).Item(0), VISIBLE=1 ;
Am I missing something ?
Thanks.
Hi @dabratt,
The issue in your scenario should be the [Date].[Date].[Date] is a key attribute. Please verify it on SSAS side.
As from here:
Best Regards,
Qiuyun Yu
Hi @v-qiuyu-msft,
Yes, [Date].[Date].[Date] is a key attribute.
It works fine when it is the only one attribute in the dimension.
If I add another attribute and attach the calculted member to it, I don't see it on the PowerBI side.
Regards,
Dabratt.
CREATE MEMBER CURRENTCUBE.[Date].[Month of Year].[LastDateDesVentes]
AS TAIL(
NONEMPTY(
[Date].[Date].[Date]
,[Measures].[Sales Amount]
)
,1
).Item(0), VISIBLE=1 ;