Counting number of "Y" in a column that only contains Y and N values

[KK111]

Hello,

I am new to Power BI and need some help please. I have a column that contains data below. I want to create a table that will include only values for "y".

When I pull Column A  into the Value field it counts both Y and N. How can I make it count only Y? Thank you. 

[Anonymous · Accepted solution]

Hi @KK111 ,

You can apply a visual-level filter on your visual: select the visual and apply the filter condition (Column A is "Y") in Filters pane just as suggested by @lbendlin . Please find more details about adding a filter to a report in the following documentation.

Add a filter to a report in Power BI

Besides that, you can create a slicer using the field Column A and create a measure as below to get the count of Column A which the value is "Y". Please find the details in the attachment.

Count of Y = CALCULATE(COUNT('Table'[Column A]),'Table'[Column A]=SELECTEDVALUE('Table'[Column A]))

Best Regards

[lbendlin]

Look in the Filter Pane, "Filters on this Visual", find Column A, set its filter to "Y".