Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi guys,
Table visualization showing the wrong total, please anybody suggest me how to resolve this one.
Total Sales = SUM(financials[ Sales])
Rank Selection = IF(SELECTEDVALUE('Rank'[Rank No]), VALUES('Rank'[Rank No]),"Please select any rank")
Rankx = IF(HASONEVALUE(financials[Month Name]),RANKX(ALL(financials[Month Name]),[Total Sales],,DESC),BLANK())
Sale = IF([Rankx] <= [Rank Selection],[Total Sales],BLANK())
regards,
Naveen
Solved! Go to Solution.
hi Guys
I changed the final measure it's working
Sale = SUMX(VALUES(financials[Month Name]),IF([Rankx] <= [Rank Selection],[Total Sales],BLANK()))
@Anonymous ,
You need to take care of the row context. Summarize or Values should help
Example
sumX(summarize(financials,financials[Month Name], "_sum",IF([Rankx] <= [Rank Selection],[Total Sales],BLANK())),[_sum])
Refer
hi Guys
I changed the final measure it's working
Sale = SUMX(VALUES(financials[Month Name]),IF([Rankx] <= [Rank Selection],[Total Sales],BLANK()))
This looks like a measure totals problem. Very common. See my post about it here: https://community.powerbi.com/t5/DAX-Commands-and-Tips/Dealing-with-Measure-Totals/td-p/63376
Also, this Quick Measure, Measure Totals, The Final Word should get you what you need:
https://community.powerbi.com/t5/Quick-Measures-Gallery/Measure-Totals-The-Final-Word/m-p/547907
User | Count |
---|---|
98 | |
91 | |
84 | |
73 | |
67 |
User | Count |
---|---|
115 | |
102 | |
98 | |
71 | |
66 |