Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
hi
I have created a dashboard with the financial sample data. the cumulative total shows correct value in the matrix, but when we export the data and do the sum, the value is different.
Fig 1: Power BI matrix table (highlighted table)
Fig2: Export
DAX:
1.
4.
Yes @amitchandak The report users are complaining this, because they are confused with the totals. Some transactions are missing, but the grand total is correct. Not sure this might be due to those transactions are filtered by the period filter. Any solution for this?
@jithinrg , Are you doing a manual total in excel? Because power bi recalculate the totals to correct then grand total
User | Count |
---|---|
98 | |
87 | |
78 | |
74 | |
70 |
User | Count |
---|---|
113 | |
105 | |
84 | |
65 | |
64 |