Aggregate Data available at day level to show sum for each month

[lovebinds]

Hi,

I have a time dimension with workday flag for each day also considering national holidays as shown in below snippet:

I am trying to create a measure which could sum up WORK_DAY_FLAG for each month, so that i can show it in tooltip of a bar chart having month name in x-axis.

The issue I am facing is it is summing up the entire year workdays and returning that value for all months, if i apply month level filter in measure that returns value specific to that month for all other months too.
The DAX I am using is below:
CY Workdays by Month = CALCULATE(SUM(WORK_DAY_FLAG),YEAR(DATE_DT) = YEAR(TODAY()))
PY Workdays by Month = CALCULATE(SUM(WORK_DAY_FLAG),YEAR(DATE_DT) = YEAR(TODAY())-1)

While Applying Month filter too:
CY Workdays by Month = CALCULATE(SUM(WORK_DAY_FLAG),YEAR(DATE_DT) = YEAR(TODAY()),MONTH(DATE_DT) <= MONTH(TODAY()))
PY Workdays by Month = CALCULATE(SUM(WORK_DAY_FLAG),YEAR(DATE_DT) = YEAR(TODAY())-1,MONTH(DATE_DT) = MONTH(TODAY()))

Any ideas would be appreciated to show Current and prior year, monthly sum of workdays.

[lbendlin]

Not clear what your expected outcome is. Read about SAMEPERIODLASTYEAR.

[lovebinds]

@lbendlin @AntrikshSharma @giorgikok @Hettic @rafaesanto83 
Please Help !! Let me know if you need any clarity on the same.