Issues with DAX Functions

[Dwisha_S]

Hi Community, 

I have a Sales Dashboard where I am calculating Month to Date Sales Target based on No of fullfillment Days that have passed. I am getting correct results for all months except March, June and November. The Sales Target does not change as the number of days change, it stays static. 

I have used below DAX Functions:
Monthly_Target_Till_Date = ABS(CALCULATE([Month_WorkingDaysthathavepassed]*(DIVIDE((SUM(Budget_File[Sum_of_Budget])/[Fulfillment_Days]),1))))

Month_WorkingDaysthathavepassed = CALCULATE([Fulfillment_Days]-[No.of_Working_Days_LeftInCurrent_Month])

Fulfillment_Days = CALCULATE(DISTINCTCOUNT('Date'[Day_Number_Year]),'Date'[Delivery_Days]="Working Day")

No.of_Working_Days_LeftInCurrent_Month = COUNTROWS(

    FILTER(

        CALENDAR(

            (Now()),

            EOMONTH ( NOW(), 0 )

        ),  WEEKDAY([Date], 2) < 6 && COUNTROWS(FILTER('Date','Date'[Delivery_Days]="Holiday")

    )

))

When I look at individual figures for June then it seems No.of_Working_Days_LeftInCurrent_Month is not executing properly at backend.

When I change it to other months then MTD Sales Target Till Date gets updated.

Please help me to resolve this issue

[Dwisha_S · Accepted solution]

This issue has been resolved. I updated the && operator to  OR "||".

No.of_Working_Days_LeftInCurrent_Month = COUNTROWS(

    FILTER(

        CALENDAR(

            (Now()),

            EOMONTH ( NOW(), 0 )

        ),  WEEKDAY([Date], 2) < 6 || COUNTROWS(FILTER('Date','Date'[Delivery_Days]="Holiday")

    )

))