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....
  • 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 )
    )
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 )
)