Forum Discussion

wasaprinters's avatar
wasaprinters
Frequent Visitor
2 years ago
Solved

Late Count Month & Employee Wise

Dear All,

 

With reference to screenshots, i wanted to make an card which show total "Late"  Month Wise of each employee.

suppose i click and Employee "ABC" so result show Total Number of Late count in Month of this emplyee. in screenshot is showing Total late arriving "34"  but this is Total Employee is late today i w

 

 

Tutorial Requests
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi wasaprinters ,

    Here is my sample data:

    You need to add another two tables for slicer without any relationship:

    Then use this DAX to create a measure:

    Count late = 
CALCULATE(
    COUNTROWS('Table'),
    ALL('Table'),
    MONTH('Table'[dail_date]) = MONTH(SELECTEDVALUE(Slicer_date[dail_date])) && 'Table'[Employee] IN VALUES(Slicer_Employee[Employee]) && 'Table'[Late Arrival] = "late"
)

    And the final output is as below:


    Best Regards,
    Dino Tao
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi wasaprinters ,

    Here is my sample data:

    You need to add another two tables for slicer without any relationship:

    Then use this DAX to create a measure:

    Count late = 
CALCULATE(
    COUNTROWS('Table'),
    ALL('Table'),
    MONTH('Table'[dail_date]) = MONTH(SELECTEDVALUE(Slicer_date[dail_date])) && 'Table'[Employee] IN VALUES(Slicer_Employee[Employee]) && 'Table'[Late Arrival] = "late"
)

    And the final output is as below:


    Best Regards,
    Dino Tao
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.