topic Re: Help - new measure to count Number of 'Yes' or 'No' values in column in DAX Commands and Tips

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

Ashleigh1904 — Tue, 06 Jun 2023 14:44:11 GMT

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,

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

Syk — Tue, 06 Jun 2023 16:25:15 GMT

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" )

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

NotMyJob — Wed, 16 Oct 2024 00:52:44 GMT

Not so fast grasshopper!! Maybe I blew something up, but this is what I get on this.

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

Spraggle — Tue, 17 Dec 2024 16:44:29 GMT

this worked a treat for me - I exactly needed YES and NO, so used your example as template and was very happy with the output - thank you.