Forum Discussion
Count Across multiple Columns
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 |
1 Reply
Hi waynep-jll ,
Result Apples = calculate(item1, filter(item1="Apples") + calculate(item2, filter (item2="Apples") + calculate (item3, filter(item3="Apples")
similarly do for bananas and carrots
please hit a thumbs up if it helps you. Thanks.
