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 lo...
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.