bundle
1 Topic
Count Number of Bundles sold based on Invoice number.
Hello, I am trying to setup a measure in Power BI that counts the number of a specific bundle that is sold at my company. I have an invoice data table along with a product table and I want to count how many times we sold the combination of "A, B, and C" Product Components on each unique invoice. In the below table the correct answer would be 2 because we have 3 positive occurrences of the bundle and 1 negative occurrence indicating a returned bundle. There are also situations where there may be 2 bundles sold on one invoice, or multiple of one item but you can only classify 1 "bundle" because the other items only have 1 unit each. Please let me know if you need more information to assist with this since I am relatively new to DAX. I greatly appreciate any assistance. Invoice Product Component Units 111 A 1 111 B 1 111 C 1 111 D 1 222 A 2 222 B 3 222 C 2 333 A 1 333 C 1 333 X 1 333 V 1 444 B 1 444 A 1 444 V 1 555 A -1 555 B -1 555 C -1Solved6.7KViews0likes28Comments