Forum Discussion
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
Community SupportHi,
According to your description, I choose one measure as an example and the others are the same.
Please take following steps:
1)Change original measures:
Sum Current IL5 Saving =
IF (
TODAY () IN FILTERS ( 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 ()
)
2)Convert axis column to Date type:
3)The result shows only today’s data:
Best Regards,
Giotto Zhi
Hello v-gizhi-msft
Thanks for the help. It works!
But I really wanted/needed the Date Hierarchy feature 😕
Is it possible to keep it?
Thanks!
- v-gizhi-msft
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
Hello v-gizhi-msft
It worked!!
Many thanks!