Forum Discussion

bgoeggel's avatar
bgoeggel
New Member
9 years ago
Solved

Rows being added in a matrix

I have a matrix that has two rows, "Purchase Order" and "Delivery Days" that I have put into a matrix. Each purchase order has several rows with a different amount of delivery days for each row in my data set. I am trying to filter out certain rows based on an amount of delivery days, but power BI automatically adds up the amount of delivery days under each purchase order.

 

For example:

Purchase Order    Delivery Days

73440                   10

73440                   12

73441                   10

73441                   12

 

Will show up in the matrix as:

Purchase Order         Delivery Days

73440                        22

73441                        22

 

I want to keep each individual row so that it filters properly. My filter is to remove all Purchase Orders with a delivery days of 10, but since they are being added up to 22, they are not being filtered out. Please help!

  • Anonymous's avatar
    Anonymous
    9 years ago

    Have you tried moving Delivery Days from the Values section of the matrix to the Rows section?

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable

    Have you tried moving Delivery Days from the Values section of the matrix to the Rows section?