Forum Discussion

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

Show intermediate sum result

Hello everyone,   First, let me excuse myself for probably a very basic question. Also, English is not my native language so i'm not even sure the title is correct, but let me show what i need, it'...
  • amitchandak's avatar
    amitchandak
    4 years ago

    MatevzP , using date table joined to you table (date from date table used in visual

    Cumm = CALCULATE(SUM(Table[documents]),filter(allselected('Date'),'Date'[date] <=max('Date'[date])))

     

    or

    Cumm = CALCULATE(SUM(Table[documents]),filter(allselected('Table'),'Table'[date] <=max('Table'[date])))

  • tamerj1's avatar
    tamerj1
    4 years ago

    MatevzP 

    In your chart, you're still using the date from the same table, right?

    try this code

    test 3 =
CALCULATE (
    COUNTROWS ( WP1_Report ),
    ALLEXCEPT ( WP1_Report, WP1_Report[Review Status] ),
    WP1_Report[Last Upload] <= MAX ( WP1_Report[Last Upload] )
)
tamerj1's avatar
tamerj1
Icon for Community Champion rankCommunity Champion
4 years ago

MatevzP 

In your chart, you're still using the date from the same table, right?

try this code

test 3 =
CALCULATE (
    COUNTROWS ( WP1_Report ),
    ALLEXCEPT ( WP1_Report, WP1_Report[Review Status] ),
    WP1_Report[Last Upload] <= MAX ( WP1_Report[Last Upload] )
)
MatevzP's avatar
MatevzP
Icon for Helper I rankHelper I
4 years ago

This one behaves the same as original DAX from amitchdak.
Both work! 🙂
Yours is a bit simpler. Thank you! 🙂