Counting Certain text and the result reflects as per the Filter applied in Slicer

[Alpha_Wolf01]

After getting the solution from my previous post

https://community.powerbi.com/t5/Desktop/Compare-values-from-columns-in-two-tables-identify-those-th...

Now Iam stuck at last step, now i need to count the word "Absent" from the Table and the count does reflect the new value whenever i choose a slicer filter as example below:

The Problem is

I have a table where its a result from a crossjoin between two other tables, i have linked above the solution that i was provided, now this table does have a date column name (Calender Date) say this column have a complete month calender and their is another date column (Check_IN Date) where the date is registered for the user when he is at Office only.

what i need is to count the days where the employee is Absent, and the value can change as per the filter i apply as example if choose Employee A with the Month March 2021, then the result will be Counting the word "Absent" for the applied two filters, some Screen Shots below i hope that it might help.

[Alpha_Wolf01 · Accepted solution]

I have Solved this issue by using the below formula:

#Count_Absent =

COUNTROWS(

FILTER(

GROUPBY(

'Table 3','Table 3'[Date_Customize],'Table 3'[Name-Database],'Table 3'[WeekEnd - WeekDay]),[Onsite-Absent Status]="Absent" && [WeekEnd - WeekDay]="Working Day"))