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

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])))