CODEWITHSUNDEEP
powerbidax
M.T Davis
M.T Davis

Reputation: 1098

Using DAX to Count or Calulate Values

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.

Upvotes: 1

Views: 171

Answers (1)

Alexis Olson
Alexis Olson

Reputation: 40204

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

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

Upvotes: 3

Related Questions