Forum Discussion
Issues with aggregating a measure.
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.
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.
