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

Hi MatevzP 

this is called Runnimg Total or Comulative Count. You can try

# Documents RT =
CALCULATE (
    DISTINCTCOUNT ( Table[Folder Name and Path] ),
    Table[Last Upload] <= MAX ( Table[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! 🙂