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

Sorry, I am an idiot.  I didn't see the double square brackets after Employee Details.  I have corrected that and am testing out the solution.  Sorry, thank you.