Count open days of any month

[Anonymous]

Hello, 

I'm working on a dax to calculate the open days in a month. For example, I would like to calculate the open days of March month. So the dax that I wrote is : 

OD = CALCULATE(DISTINCTCOUNT('Calendar'[Date]),FILTER('Calendar','Calendar'[Month]=MONTH(NOW())+1))

So the result is: 31 days, is the number of all days of March month.

Do you have any tips to calculate the open days of any month? 

Thank you in advance.

Regards,

[Anonymous]

Here's how to do that demonstrated by the Master of DAX, Alberto Ferarri: https://youtu.be/JgeUhXkxXbU

[amitchandak]

@Anonymous  ,

Not very clear what is open days?

Total day in current month = day(eomonth(Today(),0)

Total day in next month = day(eomonth(Today(),1)

[Anonymous]

@amitchandak 

Open days are the days that we work on: from Monday to Friday. For example, for March the open days are 23, not 31. I would like to calculate it for all months! 

Regards,

[amitchandak]

@Anonymous , for next month

Work Day = COUNTROWS(FILTER(ADDCOLUMNS(CALENDAR(EOMONTH(TODAY(),0)+1, EOMONTH(TODAY(),1)),"WorkDay", if(WEEKDAY([Date],2) <6,1,0)),[WorkDay] =1))