cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Frequent Visitor

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

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.

1 ACCEPTED SOLUTION
Frequent Visitor

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"))
Frequent Visitor

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"))

Announcements