Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredGet Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
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.
Solved! Go to Solution.
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
)
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
)
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
Check out the October 2025 Power BI update to learn about new features.
| User | Count |
|---|---|
| 6 | |
| 6 | |
| 4 | |
| 4 | |
| 4 |
| User | Count |
|---|---|
| 24 | |
| 17 | |
| 10 | |
| 7 | |
| 6 |