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

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
6 years ago

Move your filter inside the calculation and Try

    CALCULATE( SUM(FRAS[Money]);
    ALLEXCEPT(FRAS; FRAS[Object]; FRAS[REGION]);
    FRAS[Status] <> "Closed";
    FRAS[Category] = "IL1", filter(Calendar,Calendar[Date] = TODAY();)

 

Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks. My Recent Blog -
https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-trend/ba-p/882970
https://community.powerbi.com/t5/Community-Blog/Power-BI-Working-with-Non-Standard-Time-Periods/ba-p/881739
https://community.powerbi.com/t5/Community-Blog/Comparing-Data-Across-Date-Ranges/ba-p/823601