The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends September 15. Request your voucher.
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
)
User | Count |
---|---|
14 | |
11 | |
8 | |
6 | |
5 |
User | Count |
---|---|
28 | |
19 | |
13 | |
8 | |
5 |