Forum Discussion

TheHans's avatar
TheHans
Icon for Helper I rankHelper I
4 years ago
Solved

Create a measure with aggregated values considering existing filters

Dear Community,   I have a project table containing many projects and values per month. I would like to create a measure that accumulates all values p to a certain date but considering existing fil...
Need Help
  • mwegener's avatar
    mwegener
    4 years ago

    Hi TheHans ,

     

    try this.

    PlannedAcc = 

VAR EndDate = MAX(DateTable[Period YM]) // this is a value YYYYMM

RETURN

CALCULATE(
    SUM('FACT-Project Financials'[Value]),
    FILTER(ALL(DateTable), DateTable[Period YM] <= EndDate)
)
mwegener's avatar
mwegener
Icon for Most Valuable Professional rankMost Valuable Professional
4 years ago

Hi TheHans ,

 

try this.

PlannedAcc = 

VAR EndDate = MAX(DateTable[Period YM]) // this is a value YYYYMM

RETURN

CALCULATE(
    SUM('FACT-Project Financials'[Value]),
    FILTER(ALL(DateTable), DateTable[Period YM] <= EndDate)
)
TheHans's avatar
TheHans
Icon for Helper I rankHelper I
4 years ago

mwegener 

Thanks a lot. That helps. 

Hans