Forum Discussion

acg's avatar
acg
Icon for Resolver I rankResolver I
5 years ago
Solved

Count based on a different conditions

I need to translate this sql query:

 

SELECT COUNT (DISTINCT [Employee ID] )
FROM [IDW_mart_DEV].[dbo].[rep_timesheet_OVT]
WHERE [OT BTW 0% & 10%] = '1'
AND [quarter_offset] = '-1'

 

into DAX. how do I put in the second condition ? IN other words, how do I incorporate:

DISTINCTCOUNT (rep_time[Employee ID] ) ?  I have already a filter, filtering out [OT BTW 0% & 10%] = '1' 

Where from here?

 

CNT OT BTW 0% & 10% =
CALCULATE (
COUNT ( rep_time[OT BTW 0% & 10%]),
FILTER ( rep_time, rep_time[OT BTW 0% & 10%] =1 )
)
 
 
  • acg's avatar
    acg
    5 years ago

    ohh silly me, I just found it:

    here we go:

     

    CNT OT BTW 0% & 10% =
    CALCULATE (
    DISTINCTCOUNT (rep_time[Employee ID]),
    FILTER ( rep_time, rep_time[OT BTW 0% & 10%] =1 )
    )

1 Reply

  • acg's avatar
    acg
    Icon for Resolver I rankResolver I
    5 years ago

    ohh silly me, I just found it:

    here we go:

     

    CNT OT BTW 0% & 10% =
    CALCULATE (
    DISTINCTCOUNT (rep_time[Employee ID]),
    FILTER ( rep_time, rep_time[OT BTW 0% & 10%] =1 )
    )