Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi all,
I am wondering why the total values for the columns V and AM are inaccurate as shown below.
Kindly please help.
Thank you
Solved! Go to Solution.
Hi @JPY ,
Sometimes, we will find that it displays unexpected answers in subtotals and grand totals, here is an article which discusses about this problem, I would suggest you referring to it: https://powerpivotpro.com/2012/03/subtotals-and-grand-totals-that-add-up-correctly/
Best Regards,
Teige
Hi @JPY ,
Sometimes, we will find that it displays unexpected answers in subtotals and grand totals, here is an article which discusses about this problem, I would suggest you referring to it: https://powerpivotpro.com/2012/03/subtotals-and-grand-totals-that-add-up-correctly/
Best Regards,
Teige
Hi @JPY ,
It's a very common issue with the Power BI, insted of SUM please SUMX functio. This will resolve the issue.
To know more about how to use SUMX function, please search in youtube for SUMX, you will get to know how to use it.
Please let me know if you need any help, happy to help.
Regards,
Pavan Vanguri.
Hi @Anonymous,
Thanks for ypur reply!
I didnt any measure calculation in this table, however I only applied the normal summary in the dialogue as shown below. Please help
Thank you!
Hi @Anonymous ,
Please see the sample data as shown below.
Thanks!
User | Count |
---|---|
125 | |
106 | |
99 | |
63 | |
62 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |