matrix doesn't match table

[kitcatnj]

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 

 

[v-yueyunzh-msft · Accepted solution]

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

[rsbin]

@kitcatnj ,

Looks to me like you have 24 rows:

1 CMOS +
1 Copper Switch +
1 CPU +

21 Disks =
24

If you show Grand Total by Row in your Matrix, it should show you 24.