Forum Discussion
Values getting aggregated in matrix for 'VALUES' field
I am using Azure Analysis Service with Power BI and I am using a matrix visual where I have used 5 fields as ROWS, 1 field as COLUMN which will work as column name and finally 1 field which is used as VALUES. For 2 data entries, those 5 fields(ROWS) have exactly the same value therefore in Power BI it is coming as a single row and value is showing as "First value". When I used summarization at Azure Analysis Service and passed it to Power BI, those 2 entires are still coming as a single row but the values are now getting summed up/aggregated. Can anyone help me with this how I can avoid this aggregation in Power BI and get two separate entries of the row without getting their values getting summed up?
Note: I am using Azure Analysis Service for all the calculations. In Azure Analysis Service, they are coming in 2 separate rows as 2 individual entries, but when it comes to power bi, VALUES are getting summed up.
First image is with the value 32 which is the first value.
To solve this I did enable summarization in Azure Analysis Service and passed it to Power BI. Hence the second image is with the value 66 which is the summed up value (We have 2 entries with individual values as 32 and 34 but in Power BI it is coming as a single row with 32+34 = 66 as the aggregated value)
Hi PujaPal ,
Matrix is for aggregating values.
When two or more row have the same values completely, it will return the distinct rows content which every row value is the unique key in visuals.
In your scenario,
- When summarization was not enabled in AAS, Power BI will return the first row of value by default.
- When summarization was enabled in AAS, Power BI will return total value by default.
To prevent this situation, try what sanimesa mentioned.
Best Regards,
Icey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
4 Replies
- Icey
Community Support
Hi PujaPal ,
Matrix is for aggregating values.
When two or more row have the same values completely, it will return the distinct rows content which every row value is the unique key in visuals.
In your scenario,
- When summarization was not enabled in AAS, Power BI will return the first row of value by default.
- When summarization was enabled in AAS, Power BI will return total value by default.
To prevent this situation, try what sanimesa mentioned.
Best Regards,
Icey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.