Forum Discussion
Not aggregating values in a Matrix
We are grateful for your participation in the Microsoft Fabric Community forum.
1. Create a calculated column for Commission Rate in your product table, assuming it is a fixed value per product.
2. In the matrix visual, add Product Family and Product to the Rows. Then, add Transaction Amount and Commissions $ (as measures) to the Values, and add the Commission Rate column to the Values as well.
3. To prevent the Commission Rate from being summarized, click the dropdown arrow next to the Commission Rate in the Values section of the matrix, and select "Don't summarize". If this option is greyed out or unavailable, it means you're using a measure, not a column — and measures are always aggregated.If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.
Thanks.
May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.
Thank you.