Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 ;
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.