Count with filter based on service colomns

[dofrancis3]

Dear colleagues !

Please could you help me with DAX Mesure that can allow me to have number of each service

[dharmendars007]

Hello @dofrancis3 , 

Please try the below measures..

Number of Legal Assistance =
CALCULATE(
COUNT('Dataset'[Service]),
'Dataset'[Service] = "Legal assistance")

Number of Mental Health =
CALCULATE(
COUNT('Dataset'[Service]),
'Dataset'[Service] = "Mental health")

Number of Family =
CALCULATE(
COUNT('Dataset'[Service]),
'Dataset'[Service] = "Family")

If you find this helpful , please mark it as solution which will be helpful for others and Your Kudos/Likes 👍 are much appreciated!

Thank You

Dharmendar S

LinkedIN 

[dofrancis3 · Accepted solution]

Dear @dharmendars007 

Thank you for this proposition; but the Distinct Count should be based on the ID column insteand of service.

So, below is the solution:

Number of Mental Health =

CALCULATE(

DISTINCTCOUNT('GBV_Mapping_CAR'[ID]),

'GBV_Mapping_CAR'[Service] = "Mental health")

Number of familly =

CALCULATE(

DISTINCTCOUNT('GBV_Mapping_CAR'[ID]),

'GBV_Mapping_CAR'[Service] = "Familly")

Number of Legal Assistance =

CALCULATE(

DISTINCTCOUNT('GBV_Mapping_CAR'[ID]),

'GBV_Mapping_CAR'[Service] = "Legal Assistance")