Forum Discussion

GabrielFz's avatar
GabrielFz
Frequent Visitor
6 years ago
Solved

Sum measure fixed on a single date

Hello!  I'm really stucked on this subject, hope someone could help (:  I want to get one chart exactly as the following one, which I got using calculated columns (then the slicers filters on t...
Need Help
Tutorial Requests
  • v-gizhi-msft's avatar
    v-gizhi-msft
    6 years ago

    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