Hello, I am wondering what the best way to have power BI account for values across multiple columns. For example if I wanted to show a pie chart that counts locations that have apples, compared to locations that have bananas, compared to locations that have carrots, based on a chart that doesn't have them necessarily split by item.
If I wanted a pie chart that shows locations with Apples, Banans, and Carrots, it should read 3A/2B/3C, but I don't know how to get it to add from multiple columns but apply it to the 1 location.
| | Item 1 | Item 2 | Item 3 |
| Location 1 | Apples | Bananas | Carrots |
| Location 2 | Apples | Carrots | |
| Location 3 | Bananas | Carrots | |
| Location 4 | Apples | | |
