Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
Hello All,
I've been trying to track down an answer to my totaling issue for a specific set of data im looking at. I know the error has something to do with filters possibly in the background, but was wondering if there is a way to work around it.
Essentially, have this specific set of accounts with a value attached filtered down from a larger data set. The "Total Row" is not summing up the rows above it properly. I'm sure BI is working properly, but I just need a formula to take the value and sum it up correctly as it is displayed above. The correct value should be 1847, but it keeps displaying 1204.
This is how the data is currently being displayed in BI:
Acct Value
1 248
2 293
3 180
4 48
5 238
6 592
7 0
8 55
9 113
10 80
TOTAL 1204
Any help on this matter would be greatly appreciated.
Thanks.
Hi @Anonymous
Below are some similar posts for your reference.You may change your measure to get the correct total.
https://community.powerbi.com/t5/Quick-Measures-Gallery/Measure-Totals-The-Final-Word/m-p/547907
Regards,
Cherie
You'll have to post the DAX for any measure that shows what data you're displaying. We can't just look at it and say : "try this"
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
144 | |
87 | |
65 | |
50 | |
45 |
User | Count |
---|---|
217 | |
88 | |
81 | |
65 | |
56 |