Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
VendettaBob
Helper II
Helper II

DISTINCTCOUNT ALL and FILTER

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?

 

1 ACCEPTED SOLUTION
Nathaniel_C
Super User
Super User

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





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




View solution in original post

1 REPLY 1
Nathaniel_C
Super User
Super User

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





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.