Forum Discussion
matrix doesn't match table
I am recreating an excel file in power bi.
I have a 1 tab with data, and a 2nd tab with a pivot.
I created a table in power bi which matches perfectly to the table in excel.
I created to matrix (to simulate the pivot from excel) and my numbers don't match.
Rows in the table equal 24. So does the excel pivot. My power bi matrix says 21.
Can someone please tell me where my mistake is? I am sure it's simple, but i'm new to power bi and can't easily
Hi, kitcatnj
According to your image,it seems the same in table and matrix.
In your table , you put Category on the row, so there is no grouping for the total, shown as the total number of all Catogory 24.
In your Matix, you put the "Catrgory" on the colum , so the value in Matrix is calculated for each different Category grouping, you can try to add the Count in Matrix. 21+1+1+1=24 . it is the same as in the "Table".
It measn when the Item ="Appliance" and Category="Disk" , the count =21.
Thank you for your time and sharing, and thank you for your support and understanding of PowerBI!
Best Regards,
Aniya Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
2 Replies
- v-yueyunzh-msft
Community Support
Hi, kitcatnj
According to your image,it seems the same in table and matrix.
In your table , you put Category on the row, so there is no grouping for the total, shown as the total number of all Catogory 24.
In your Matix, you put the "Catrgory" on the colum , so the value in Matrix is calculated for each different Category grouping, you can try to add the Count in Matrix. 21+1+1+1=24 . it is the same as in the "Table".
It measn when the Item ="Appliance" and Category="Disk" , the count =21.
Thank you for your time and sharing, and thank you for your support and understanding of PowerBI!
Best Regards,
Aniya Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
