Not aggregating values in a Matrix

Hi senthilvaithi 

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.