Forum Discussion

kitcatnj's avatar
kitcatnj
Frequent Visitor
3 years ago
Solved

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 matr...
Need Help
  • v-yueyunzh-msft's avatar
    v-yueyunzh-msft
    3 years ago

    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

v-yueyunzh-msft's avatar
v-yueyunzh-msft
Community Support
3 years ago

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