Forum Discussion
Difference between grand total and rows total
Hi,
Can you, please, help me with an solution for the issue I am encountering? Basically for the same ID (which is the key between my tables) and opportunities the grand total is doing a distinct sum and I want to return the overall value, for all employees.
Many thanks in advance for your support.
| Name | ID | Opp | Amount Power BI |
| Joana | 281589 | OPE-0005867438 | 9460 |
| Erik | 500212925 | OPE-0005977363 | 31501 |
| Stela | 255869 | OPE-0006077863 | 0 |
| Joana | 281589 | OPE-0006393321 | 50899.88 |
| Joana | 775025 | OPE-0006491650 | 20699.28 |
| Stela | 500220604 | OPE-0006949387 | 10000 |
| Andreea | 500220604 | OPE-0006949387 | 10000 |
| Stela | 500220604 | OPE-0007228870 | 3000 |
| Andreea | 500220604 | OPE-0007228870 | 3000 |
| Erik | 500220604 | OPE-0007228901 | 10000 |
| Stela | 500220604 | OPE-0007228901 | 10000 |
| Grand total Power BI | 135560.16 | ||
| Grand total Excel | 158560.16 | ||
| Difference Excel vs Power BI | 23000 |
4 Replies
v-piga-msftResident Rockstar
Hi gstefan,
Based on your data sample, I have a little confused about the Grand total of excel. Where is the data about Excel in the sample?
Basically for the same ID (which is the key between my tables) and opportunities the grand total is doing a distinct sum and I want to return the overall value, for all employees.
By my calculate, all of amount of Power BI should be 158560.16. What result do you want to get?
Could you describe your problem in more details?
Best Regards,
Cherry
- Hi,
Power BI shows a grand total of 135560.16 and not 158560.16..the last one I want to be returned.
Thank you- v-piga-msft
Hi gstefan,
Do you mean that the total of Amount of Power BI in this data sample is 135560.16 in your Power BI?
If it is, by my test with your data, the grand total shows 158560.16 in my side like below.
If you still have the issue, please share a dummy pbix file which can reproduce the scenario, so that I could test on it in my side? You can upload it to OneDrive or Dropbox and post the link here. Do mask sensitive data before uploading.)
If I misunderstand your issue, could you share a screenshot to specify your scenario?
Best Regards,
Cherry
Hi,
Can you, please, help me with an solution for the issue I am encountering? Basically for the same ID (which is the key between my tables) and opportunities the grand total is doing a distinct sum and I want to return the overall value, for all employees.
Many thanks in advance for your support.
Name ID Opp Amount Power BI Joana 281589 OPE-0005867438 9460 Erik 500212925 OPE-0005977363 31501 Stela 255869 OPE-0006077863 0 Joana 281589 OPE-0006393321 50899.88 Joana 775025 OPE-0006491650 20699.28 Stela 500220604 OPE-0006949387 10000 Andreea 500220604 OPE-0006949387 10000 Stela 500220604 OPE-0007228870 3000 Andreea 500220604 OPE-0007228870 3000 Erik 500220604 OPE-0007228901 10000 Stela 500220604 OPE-0007228901 10000 Grand total Power BI 135560.16 Grand total Excel 158560.16 Difference Excel vs Power BI 23000
