Running Total with Matrix(Year of date)

Khalandar — Mon, 12 May 2025 17:41:36 GMT

Hi,

I am new to Power BI. I am facing an issue with Running Total in Matrix visual as below mentioned.
When I am using single year as 2016, it will giving correct value.

but once I am using multip years the flow was breaking, as you can see below image

here is the dax expression I am using for this

can someone help where I am doing wrong ?
Thanks for advance
Khalandar.

Re: Running Total with Matrix(Year of date)

Jihwan_Kim — Mon, 12 May 2025 22:08:01 GMT

Hi, I am not sure how your semantic model looks like, but if you are looking for the selected years rank, please check the below picture and the attached pbix file.

I think, please correct me if I am wrong, in each year, the ranking of cities are different. If you want to rank the cities for all selected years, please check the below.
Window DAX function is used in the measure.

WINDOW function (DAX) - DAX | Microsoft Learn

total sales: = SUM( orders_fact[sales] )

cumulative sales: = VAR _cumulate = WINDOW ( 1, ABS, 0, REL, ALL ( city_dimension[city] ), ORDERBY ( CALCULATE ( [total sales:], ALLSELECTED ( year_dimension[year] ) ), DESC ) ) RETURN CALCULATE ( [total sales:], _cumulate )

topic Re: Running Total with Matrix(Year of date) in DAX Commands and Tips

Running Total with Matrix(Year of date)

Re: Running Total with Matrix(Year of date)