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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
kstaszak
Frequent Visitor

Issues with aggregating a measure.

Hello,

 

I am experiencing very weird issue while analyzing the data from SSAS Tabular Model Cube chained (or linked if you prefer) measures.

Please allow me to use an example:

 

I do have a table with project budgets and columns Client Budget and Investment Budget. In this table in the cube I created three measures:

 

MeasureA := SUM([Client Budget])

MeasureB := SUM([Investment Budget])

MeasureC := MeasureA + MeasureB

 

My table with budgets has a reference to project dimension so I can slice this data by for example project name. In PowerBI desktop I have created a table with following columns: Project name|MeasureA|MeasureB|MeasureC and I am experiencing following issue - whenever I refresh the data with Refresh button (data in DB and cube is not changing, just refreshing the report view) results of MeasureC are different instead of being a sum of Measures A and B all the time. Weirdly every time I hit refresh MeasureC is either 

- 0

- equal MeasureA

- equal MeasureB

- correct and equal a sum

 

When I connect to the cube through power pivot or directly from SSMS browser the values are always correct which is leading me to believe that formulas are correct and something is off with the PowerBI desktop.

 

3 REPLIES 3
ankitpatira
Community Champion
Community Champion

@kstaszak My guess would be that you have either got some filtering applied on the project name or in the cube measures are in a seperate table ie giving you sum of all the values in column but in pbi desktop when you import it along with project names, sum is only returning values where there is a project name association.

 

What I would suggest you do is in power bi desktop import both the tables first ie seperate projects table and seperate measures table and then create realationship between then and then check measure values.

Hi @ankitpatira, thank you for the response, however this one does not solve my problem. I do not have additional filters, also my schema is already structer as a star schema, so there is a dimensions table and a relation to the table where my  measures are. The schema and relations are fine since the measures are working properly in other clients apart from PowerBi desktop.

@kstaszak

 

I haven't reproduced your issue. No matter how I refresh the data, all three measures always show correct values. Please update your Power BI Desktop into latest version and try again.

 

66.PNG

 

77.PNG

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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