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 have this summarized dataset grouped by multiple variables.
This is a screenshot of a table I created from the dataset (other variables are being used as slicers), each index point has mulitple rows in the main dataset
2023 is defined as CALCULATE(SUM('Append1'[STARTS]), 'Append1'[COMPYEAR] IN { 2023 })
2022 is defined as CALCULATE(SUM('Append1'[STARTS]), 'Append1'[COMPYEAR] IN { 2022 })
You can create 2 separate running totals:
RunningTotal_2023 =
VAR CurrentIndex = MAX('Table'[Index])
RETURN
CALCULATE(
SUM('Table'[2023]),
FILTER(
ALL('Table'),
'Table'[Index] <= CurrentIndex
)
)
RunningTotal_2022 =
VAR CurrentIndex = MAX('Table'[Index])
RETURN
CALCULATE(
SUM('Table'[2022]),
FILTER(
ALL('Table'),
'Table'[Index] <= CurrentIndex
)
)
I should have cleared this ealier but the "Index" col is exactly not an index column. So I have a text field with 7 different values in it and I duplicated that col and just replaced those values with numeric values to able to sort them
You mean a running total?
RT 2023 = VAR mi=MAX(Append1'[Index]) RETURN CALCULATE(SUM('Append1'[STARTS]), 'Append1'[COMPYEAR] IN { 2023 }, 'Append1'[Index] <= mi)
I should have cleared this ealier but the "Index" col is exactly not an index column. So I have a text field with 7 different values in it and I duplicated that col and just replaced those values with numeric values to able to sort them. And using the formula you provided I see it replicating the values
Well, a column is column. What isn't clear from what you've shared so far is what table that column is on, so I assumed it was in the same table.
If that "Index" column is on some linked (dimension) table it would explain why the code I sent earlier doesn't work, you would have to change it to something like:
RT 2023 = VAR mi=MAX(SomeDimensionTable[Index]) RETURN CALCULATE(SUM('Append1'[STARTS]), 'Append1'[COMPYEAR] IN { 2023 }, SomeDimensionTable[Index] <= mi)
The 'Index' col is in 'Append1' table
well, the measure works fine in my local example, so there must be other columns, filters or relationships in your model that cause the preceeding indexes to be filtered out.