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] )
)
MatevzP's avatar
MatevzP
Icon for Helper I rankHelper I
4 years ago

Hi,

Thanks for your reply as well, but answer from Mr. amitchandak works better in my scenario.

 

I did two versions of your DAX, one distinct and one just count.

DISTINCTCOUNT (folder paths are always the same, hence 1)

 

COUNT (counts, but as originally, goes up and down)

 

DAX:

test 2 = 
CALCULATE(
    COUNT(WP1_Report[Folder Name and Path]),
    WP1_Report[Last Upload] <= MAX(WP1_Report[Last Upload])
)

test 2 = 
CALCULATE(
    DICTINCTCOUNT(WP1_Report[Folder Name and Path]),
    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! 🙂