Forum Discussion

paulvans182's avatar
paulvans182
Icon for Helper III rankHelper III
5 years ago
Solved

Count Employees with Multiple Interviews on Same Day

Good morning,   This is a bit of an extension of a previously answered question: DAX Count Records that have changed values   I have a data model that looks as follows:   The Scenario: E...
Need Help
  • amitchandak's avatar
    amitchandak
    5 years ago

    paulvans182 , Try like

    Check =
    var _tab = filter(Summarize(Interview_Fact,[EmployeeID],Interview_Fact[Date],"_1", distinctCOUNT(Interview_Fact[Interview Details]])),[_1] >1)
    return
    countx(summarize(_tab,[EmployeeID]),[EmployeeID])

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

paulvans182 , Try like

Check =
var _tab = filter(Summarize(Interview_Fact,[EmployeeID],Interview_Fact[Date],"_1", distinctCOUNT(Interview_Fact[Interview Details]])),[_1] >1)
return
countx(summarize(_tab,[EmployeeID]),[EmployeeID])

paulvans182's avatar
paulvans182
Icon for Helper III rankHelper III
5 years ago

Good morning amitchandak ,

 

Thank you for the response, although it appears there is an error in the expression.  I tried to insert it and get the following issue:

 

Is there perhaps a typo in your response?  I can't seem to spot the cause.

 

Thanks again for the help, I really appreciate it.