Forum Discussion
Power BI Matrix total issue - Need help
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
8 Replies
Create a measure to sum quantity
Quantity = SUM ( table[Quantity] )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
Still getting same total... No change
Are you sure there is no issue with data modelling?
You can try to use measures as SUM
Hi,
Share the download link of the PBi file.
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.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
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.
