- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page

# Calculating Working Days correctly, but filter context for Month not working

[ Edited ]- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

11-05-2018 02:32 PM - edited 11-05-2018 02:54 PM

See link above for sample calendar that is calculating working days.

The Matrix visual demonstrates that my method of determining a working day less holidays if functionally working. Example first day of the year is New Years Day which falls on a Monday, which would normally be a working day, however because it is a holday the matrix is showing as Zero for the first Monday of the year and a One for the second Monday of the year. So determining a working day minus holidays is working in my Power BI sample.

However, when I create a Month Name as the filter context and count rows that are working days

Count working days = CALCULATE(COUNTROWS(dates),FILTER(dates,dates[isworkingday]=1))

the table filter context is not working, instead of the actual days of work per month, it is showing 255 days.

I'm a newbie to Power BI, excuse me if the answer is simple, but not obvious to me, need help

Solved! Go to Solution.

Accepted Solutions

## Re: Calculating Working Days correctly, but filter context for Month not working

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

11-05-2018 05:31 PM

Hi surfingjoe,

Try just using SUM.

Count working days = SUM(dates[isworkingday])

Tell us if works for you.

All Replies

## Re: Calculating Working Days correctly, but filter context for Month not working

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

11-05-2018 05:31 PM

Hi surfingjoe,

Try just using SUM.

Count working days = SUM(dates[isworkingday])

Tell us if works for you.

## Re: Calculating Working Days correctly, but filter context for Month not working

[ Edited ]- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

11-05-2018 05:59 PM - edited 11-05-2018 06:00 PM

Never thought to simply use SUM. Normal thought process is towards counting the working days, but since each true workinday is represented by a 1 and non working days represented by 0, then using SUM works. Thank you.