Count occurrences of Yes values

[yabasha]

Hi,

I have excel data imported into power bi and one of the columns is yes_no column which lists people who said yes and who said no and I want to count the numbe of Yes and the number of No and display the result in pie chart, I tried many solutions for my issue but nothing worked, I could do that in excel with countif() but not in power bi.

Please Advice,

[v-qiuyu-msft · Accepted solution]

Hi @yabasha,

You can create a measure below: 

Percentage = DIVIDE(COUNT(Table1[yes_no]),CALCULATE(COUNT(Table1[yes_no]),ALL(Table1))) 

Or you can drag the yes_no column to pie chart Values section and set the "Percent of grand total". 

For details, you can download attached pbix file. 

Best Regards,
Qiuyun Yu 

[yabasha]

I want to display the result as percentage.

Thanx,