Count Across multiple Columns

[waynep-jll]

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

[truptis]

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.