Using DAX to Count or Calulate Values

0
votes

I'm trying to create a measure in Power BI and I'm having some trouble.

I have a table called 'clients' which as a column called 'status' that has multiplies values in it.

I want to create a formula that counts the number of how many times the value 'Kept' shows up in that column. 

Total = COUNT('client'[status])

I'm just not sure where to go from here. I don't know if COUNT or SUM would be the correct function. I know this is a simple solution but I can't figure this out.

1
powerbidax

1 Answers

2
votes

The CALCULATE function allows you to add simple filters using additional arguments.

CALCULATE(
    COUNT('client'[status]),
    'client'[status] = "Kept"
)