Sum the Total days per month when filtered by Year

[Anonymous]

Hi Community,

I am new to power BI, and facing a problem when calculatinig total days in year for each month.

I could achieve getting the number of days per month by using NumberDaysMonth = DAY(ENDOFMONTH('Calendar'[Date])) however, I need their sum when we filtered with year 

for example:

Scenario 1: When year slicer filtered  for 2011 ( march,april,may) the total would be 92 (31 + 30+31).

Month	Days in Month
October	30
December	31
September	30
November	31
	122

Can any one help me on urgent bases.

All help will be appreciated.

Thank you so much

[v-chuncz-msft · Accepted solution]

@Anonymous,

You may try a similar way as shown here.

[Zubair_Muhammad]

@Anonymous

What do you get if you use a MEASURE like

Measure = Count('Calendar'[Date])

[Anonymous]

Thanks For your reply,

Below is the output i am getting.

Month	Days in Month
October	22
December	22
September	22
November	22
	88