Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

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.

Reply
cyclist007
Responsive Resident
Responsive Resident

SSAS based Calculated Measure not working in Gauge against a date attribute (non-key attribute)

Hi, 

 

I am running into the following issue: A calculated measure in SSAS is only working in Power BI when plotted against the key attribute of Date dimension but not when plotted only against an attribute which is not a key.  Due to this we are not able to use this measure in plotting a gauge against an attribute of Date dimension which is not based on key attribute. This works fine when used in table visual. See attached image. Does anybody know the reason or workaround for this? Thanks

 

 

Calculated Measure not working in a Gauge.PNG

 

Calculated Measure not working in a Gauge 2.PNG

1 REPLY 1
v-ljerr-msft
Employee
Employee

Hi @cyclist007,

 

It seems that the calculated measure needs a specific date context for calculation. Could you post the formula of the calculated measure, so that we can help further investigate on it? Smiley Happy

 

Regards

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.