Sum measure fixed on a single date

Hi,

Please change original measure to this:

Sum Current IL5 Saving =

IF (

    TODAY () >= MIN('Calendar_A110'[Date]) && TODAY() <= MAX('Calendar_A110'[Date]),

    CALCULATE (

        SUM ( FRAS[Saving Adj] ),

        ALLEXCEPT (

            FRAS,

            FRAS[Object],

            FRAS[REGION],

            FRAS[Cell],

            FRAS[Cell Label],

            FRAS[PCR_Category],

            FRAS[labels],

            FRAS[PROJECT],

            FRAS[Responsible Group Merged],

            FRAS[status],

            FRAS[IL-Level (Adjusted)],

            FRAS[Concluded Milestone],

            FRAS[Plan],

            FRAS[Waiting List]

        ),

        FRAS[PCR Status] <> "Dropped",

        FRAS[IL-Level (Adjusted)] = "IL5"

    ) / 1000,

    BLANK ()

)

And the result does not display due to your page filter and today’s data does not meet this filter.

In order to show the result, I temporarily remove this page filter to test.

I have kept the date hierarchy and now the result shows:

Best Regards,

Giotto Zhi