Forum Discussion
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!
- Anonymous9 years ago
Have you tried moving Delivery Days from the Values section of the matrix to the Rows section?
1 Reply
- AnonymousNot applicable
Have you tried moving Delivery Days from the Values section of the matrix to the Rows section?