Rows being added in a matrix

[bgoeggel]

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 · Accepted solution]

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