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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

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
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

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

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.