Count of Total Customers by Tasks

DAX DAX Calculations
1

Hi everyone, I was puzzle how to count the total number of customers by Tasks by the given below scenario. Thanks in advance :slight_smile:

Two tables have the inactive relationships: Tasks[Jobs Job Client ID] and Clients[ID]

DAX measure

Total Customers by Tasks = 
CALCULATE (
    DISTINCTCOUNT ( Clients[ID] ),
    FILTER ( Clients, Clients[Is Prospect] = "No" ),
    USERELATIONSHIP ( Clients[ID], Tasks[Jobs Job Client ID] )
)

image

image
image688×513 10 KB

2

Hi @ronald_balza, I think you want to be counting from the Tasks table and not the Clients table.

So something like:

Total Customers by Tasks = 
CALCULATE (
    //DISTINCTCOUNT ( Clients[ID] ),
    DISTINCTCOUNT ( Tasks[Jobs Job Client ID] ),
    FILTER ( Clients, Clients[Is Prospect] = "No" ),  
   //KEEPFILTERS (Clients[Is Prospect] = "No" ),  <-- would work too
    USERELATIONSHIP ( Clients[ID], Tasks[Jobs Job Client ID] )
)

Hope that helps, else would need to see your model :v:

Cheers
M

2 Likes