startofmonth function

[akramayman]

I have an issue my dax using the startofmonth function and in total it gives me the value of Jan 
where i can´t make a relation between date table and the 'Corporate Forecast' table. 

CALCULATE(

        sum('Corporate Forecast'[Month Value]),

        FILTER(

                'Corporate Forecast',

                STARTOFMONTH('Table'[Date])

                 = 'Corporate Forecast'[Start Date (help)]

                    && 'Corporate Forecast'[Report] = "CLOSED"

            )

        )

    +

    CALCULATE(

                SUM('Corporate Forecast'[Month Value]),

                FILTER(

                    'Corporate Forecast',

                    STARTOFMONTH('Table'[Date])

                     >= 'Corporate Forecast'[Forecast Start Date]

                        && STARTOFMONTH('Table'[Date])

                         <= 'Corporate Forecast'[Forecast End Date]

                        && 'Corporate Forecast'[Report] = "ORDER"

                )

    )

    +

    CALCULATE(

                sum('Corporate Forecast'[Month Value Opp]),

                FILTER(

                    'Corporate Forecast',

                    STARTOFMONTH('Table'[Date])

                     >= 'Corporate Forecast'[Start Date Opp]

                        && STARTOFMONTH('Table'[Date])

                         <= 'Corporate Forecast'[End Date Opp]

                        && 'Corporate Forecast'[Report] = "Opportunity"

                )

    )

[v-xinruzhu-msft · Accepted solution]

Hi @akramayman 

Try to add allselected() .

e.g

CALCULATE(
        sum('Corporate Forecast'[Month Value]),
        FILTER(
                ALLSELECTED('Corporate Forecast'),
                STARTOFMONTH('Table'[Date])
                 = 'Corporate Forecast'[Start Date (help)]
                    && 'Corporate Forecast'[Report] = "CLOSED"
            )
        )

Best Regards!

Yolo Zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.