Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.
I am trying to calculate the running total of a set of measures by months in my matrix. The running total is working by itself, however when used with my monthly slicer it breaks. I want it to calculate up to the month selected in the slicer, but instead it filters for that specific month.
example: when I select May I want to see running total froo every month from Jan to May but it shows me data only in the month of May.
Running Total = CALCULATE
( SUM ( Table[column] ),
FILTER ( ALLSELECTED( Table ),
Table[columnDate] <= MAX ( Table[ColumnDate] ) ) )
The Month Slicer comes from Table[ColumnDate].Month
Hi,
Here's my approach:
Total = SUM(Table[Column])
Total YTD = CALCULATE([Total],DATESYTD(Calendar[Date],"31/12"))
Hope this helps.
Perhaps:
Running Total = CALCULATE
( SUM ( Table[column] ),
FILTER ( ALLEXCEPT( Table[ColumnDate ),
Table[columnDate] <= MAX ( Table[ColumnDate] ) ) )