Help - new measure to count Number of 'Yes' or 'No' values in column

[Ashleigh1904]

Help! I am new to Power BI and I need to work out how to create a measure to count all the number of 'Yes' or 'No' responses within a specific column of a table.....can anyone direct me for which formula I need?

Thanks in advance,

[Syk]

There are a few ways you can do this depending on your use case! Here's an example of creating 2 measures for each yes and no. Plug in your table and column names and it should work for you.

number of yes = CALCULATE (
    COUNT ( 'Table'[ID] ),
    'Table'[yes/no column] = "Yes"
)

number of no = CALCULATE (
    COUNT ( 'Table'[ID] ),
    'Table'[yes/no column] = "No"
)