Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Count if DAX Help :)

Hello all,   I have two tables, fBrazilBadge (badge swipes for brazil) and fHeadcount (global employee records). fBrazilBadge is linked to a date table. So far I have validated that I am getting th...
Need Help
  • Mikelytics's avatar
    Mikelytics
    3 years ago

    so I assume that in the headcoun table each employee has only one assgigned location. The measure could look like this

     

    Batch-In Count of employees =
SUMX(
   BatchTable,
   CALCULATE(
      IF(SELECTEDVALUE(BatchTable[Location ID] = SELECTEDVALUE(HeadCountTable[Location ID],1,0)
   )
)

     

    But for my current understanding you would nee to creat the relation via the employee table because you want to check whether the employee batches withint the home location.

     

    Best regards

    Michael

    -----------------------------------------------------

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. Appreciate your thumbs up!

    @ me in replies or I'll lose your thread.

Mikelytics's avatar
Mikelytics
Resident Rockstar
3 years ago

Hi  Anonymous,

 

First questions which arises for me is: Does the table fHeadcount have an EmployeeID? What is the granularity of this table? Because it seems not right to creat a relation over the location ID.

 

Best regards

Michael