Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Count total working days

I have 2 tables:   attendance table: Id Name Date New id attendance  Clock in Clock Out Absent 1 Lebron 6/1/2022  1-06  00:00:00  00:00  TRUE 1 Lebron 6/2/2022  1-06   07:...
DAX
Help Request
  • Jihwan_Kim's avatar
    Jihwan_Kim
    4 years ago

    Hi,

    If you can create a relationship between two tables via New Id column and New Id Attendance column, please try using RELATEDTABLE DAX function for creating a calculated column.

    Please check the below picture and the attached pbix file.

     

     

    Total days work CC =
COUNTROWS (
    FILTER ( RELATEDTABLE ( Attendance ), Attendance[Absent] = "Present" )
)

     

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi Anonymous ,

Maybe you can try to use a measure.

Measure =
CALCULATE (
    COUNTROWS ( attendance ),
    FILTER (
        ALL ( attendance ),
        attendance[New id attendance ]
            = SELECTEDVALUE ( attendance[New id attendance ] )
            && attendance[Name] = SELECTEDVALUE ( attendance[Name] )
            && attendance[Absent] = " Present"
    )
)

Best Regards
Community Support Team _ Polly

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