Forum Discussion
Helper IIChanging Total Value based on Date Slicer
Hello,
I am trying to get the total per column as a cell in the table visual based on a date filter. Here is some sample data:
| Date | Volume |
| 1/1/2021 | 5 |
| 1/2/2021 | 10 |
| 1/3/2021 | 15 |
| 1/4/2021 | 20 |
| 1/5/2021 | 25 |
| 1/6/2021 | 30 |
| 1/7/2021 | 35 |
| 1/8/2021 | 40 |
| 1/9/2021 | 45 |
The measure would calculate the total of Volume based on a date slicer, so a sample output based on 1/1/2021-1/5/2021 would be:
| Date | Volume | TotalVolume |
| 1/1/2021 | 5 | 75 |
| 1/2/2021 | 10 | 75 |
| 1/3/2021 | 15 | 75 |
| 1/4/2021 | 20 | 75 |
| 1/5/2021 | 25 | 75 |
If the slicer was 1/1/2021 - 1/3/2021, we'd get 30 for TotalVolume instead of 75. So we want the TotalVolume to be based on the date slicer.
Please help and thanks in advance!
kirbynguyen add a measure:
total for selected dates = CALCULATE ( SUM ( 'Table'[Volume] ), ALLSELECTED() )Check my latest blog post Comparing Selected Client With Other Top N Clients | PeryTUS I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!
⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡
1 Reply
- parry2k
Super User
kirbynguyen add a measure:
total for selected dates = CALCULATE ( SUM ( 'Table'[Volume] ), ALLSELECTED() )Check my latest blog post Comparing Selected Client With Other Top N Clients | PeryTUS I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!
⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡