DISTINCTCOUNT ALL and FILTER

[VendettaBob]

Hi,

I basically want to return all the dates but where a driver Driver Status = 'Active'

So I have the DAX Code:

 CALCULATE(DISTINCTCOUNT('Dim Driver'[Driver Id]),ALL('Dim Date'[Day Date]))

But I need to add a filter to the DISTINCTCOUNT where 'Dim Driver'[Driver Status] = "Active"

Any ideas?

[Nathaniel_C · Accepted solution]

Hi @VendettaBob ,

CALCULATE takes multiple filters, have you tried:

CALCULATE(DISTINCTCOUNT('Dim Driver'[Driver Id]),ALL('Dim Date'[Day Date]),'Dim Driver' [Driver Status]="Active")

If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
Nathaniel