Counting number of occurences in a column using countrows

[EthEl_2426]

Hello, I have got a column showing status of deals i.e. Oplen, Lost and Won. I would like to use dax syntax to get the value under a measure. The code below i have used is retuning an error message "Too few arguments were passed to the CONTAINS function. The minimum argument count for the function is 3."

Lost Deals =

//Calculates the number of rows with data set to "Lost"

COUNTROWS(FILTER('Pipeline', CONTAINS('Pipeline'[Status], "Lost")))

 

Thank you in advance.

[johnt75]

You need the table as the first argument to CONTAINS

Lost deals =
COUNTROWS (
    FILTER ( 'Pipeline', CONTAINS ( 'Pipeline', 'Pipeline'[Status], "Lost" ) )
)

[Arul · Accepted solution]

@EthEl_2426 ,

try this,

Count of Status Lost = 
CALCULATE(COUNTROWS('Table'),'Table'[Status] = "Lost")

Result:

Thanks,

Arul