Forum Discussion
Cumulative Total
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') )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.
2 Replies
Hi,
Have you tried ALLSELECTED instead of ALL?
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.
