Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
93 | |
84 | |
66 |