I have a table in powerpivot showing invoices, and two calculated columns to identify Product A (1) or Product B (2)
<tbody>
</tbody>
I want to be able to write a measure that will identify if each invoice has both "True" in calculated columns 1 and 2.
That way when I pivot it out, I can see the invoice number, products bought, total spend, and if a true/false if the invoice has both products A and B.
Any Suggestions?
Invoice | Product | Units | Price | Calculated Column 1 | Calculated Column 2 |
100 | A | 1 | 100 | True | False |
100 | B | 1 | 50 | False | True |
101 | C | 1 | 100 | False | False |
101 | A | 1 | 100 | True | False |
101 | D | 1 | 25 | False | False |
102 | B | 1 | 50 | False | True |
102 | A | 1 | 100 | True | False |
102 | C | 1 | 100 | False | False |
<tbody>
</tbody>
I want to be able to write a measure that will identify if each invoice has both "True" in calculated columns 1 and 2.
That way when I pivot it out, I can see the invoice number, products bought, total spend, and if a true/false if the invoice has both products A and B.
Any Suggestions?