Don't miss your chance to take the Fabric Data Engineer (DP-600) exam for FREE! Find out how by attending the DP-600 session on April 23rd (pacific time), live or on-demand.
Learn moreNext up in the FabCon + SQLCon recap series: The roadmap for Microsoft SQL and Maximizing Developer experiences in Fabric. All sessions are available on-demand after the live show. Register 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
)
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.
A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.
| User | Count |
|---|---|
| 6 | |
| 6 | |
| 3 | |
| 2 | |
| 2 |
| User | Count |
|---|---|
| 21 | |
| 12 | |
| 9 | |
| 5 | |
| 5 |