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] )
)
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
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])))

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

    Hi, thank you for your reply!

    It seems like (to my untrained eye), that you are working with two tables here. One being table[documents] and another one being table[date].

    In reality, i only have one table. I probably didn't explain it well in OP.
    This is how it looks like:

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

    Ok, it works!

    I took your DAX formula and somehow applied to my scenario. Not exactly sure how it works, but it does.


    month, ok

     

    DAX:

     

    test = CALCULATE(COUNT(WP1_Report[Last Upload]), FILTER(ALLSELECTED(WP1_Report[Last Upload].[Date]), WP1_Report[Last Upload].[Date]<=MAX(WP1_Report[Last Upload])))