How do i make a measure that will give me count of a specific value from a column in table?

[alexw94]

So, I have table I created in my power query editor. I have a column that has values Red, Yellow, Blue & Green. I want to create a card visual that shows a quantity of how many times "Red" has appeared on my card visual.

The way I want to do this is by making a measure on Power BI that will give a count of that specific value ("Red"). 

What would the DAX formula for me to obtain this please?

[yyzheng12]

DAX:

Count_Red = calculate(countrows(table), table[column_color] = "Red")

Or you can make a card directly from the column and filter the values in the "Filter" pane.

[tamerj1]

Hi @alexw94 

Measure =
COUNTROWS ( FILTER ( 'Table', 'Table'[Value] = "Red" ) )