Cumulative Total

[NewbieJono]

i have a cumulative total that seems to work fine. however when I add a date drill down it seems to stip working.

The table on the top works and shows 1119014. However below when I  add date it shows 64700. I need this to still show 1119014

dax is:

Total = 
CALCULATE (
    [Daily Volumes],
 ALL ('DIM - Days Bridge Table') )

[v-kaiyue-msft · Accepted solution]

Hi @NewbieJono ,

Thanks to @MNedix  for the reply, please allow me to provide another insight:

You can use the following measures, use the IF() + HASONEVALUE() function to determine the data level, and then perform different calculations based on the level.

I created this data.

1. Create a measure.

_sum =
SUM('Table'[value])

2. Create measure to calculate total.

Total =
IF(HASONEVALUE('Table'[date]),
SUM('Table'[value]),
CALCULATE
(SUM('Table'[value]),
ALL('Table')))

If your Current Period does not refer to this, please clarify in a follow-up reply.

Best Regards,

Clara Gong

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[MNedix]

Hi,

Have you tried ALLSELECTED instead of ALL?