Power BI Matrix total issue - Need help

[Maya2988]

Hi All,

I am having Power BI with table having data s like below

When I- am trying to create matrix for this getting total as like below which is wrong

Basically I am expecting value as like below

If you will give answer for this then which is more helpful for us

Thanks,

Maya

[Anonymous]

Hi @Maya2988 

Could you please confirm if you've submitted this as an idea in the Ideas Forum? If so, sharing the link here would be helpful for other community members who may have similar feedback.

If we don’t hear back, we’ll go ahead and close this thread. For any further discussions or questions, please start a new thread in the Microsoft Fabric Community Forum  we’ll be happy to assist.

Thank you for being part of the Microsoft Fabric Community.

[Anonymous]

Hi @Maya2988 

I wanted to check if you had the opportunity to follow up on our previous conversation. If yes can you please provide the sample data so that we can provide you with the accurate and correct solution. 

Please feel free to contact us if you have any further questions. 

Thank you

[Anonymous]

Hi @Maya2988 
Thank you for reaching out microsoft fabric community forum.
Could you please provide a sample PBIX file so that we can assist you more efficiently?
Thank you.

[Ashish_Mathur]

Hi,

Share the download link of the PBi file.

[Maya2988]

Still getting same total... No change

[SafdarHussain]

Are you sure there is no issue with data modelling? 
You can try to use measures as SUM

[SafdarHussain]

Creating a measure that counts Comp1 individually for Column1 and using that measure in this matrix might help - let me know what you did - quite curious

[Deku]

Create a measure to sum quantity

Quantity = SUM ( table[Quantity] )