Forum Discussion
DwiveSh
5 years agoNew Member
Grand Total Value is not correct year wise.
Dear Team,
Greetings!!!
I amnew to power BI dasboard designing, created one Bar graph to see the distinct sum of year wise. But grand total value is not correct, once converted into pivote table and check with Quarter wise data it is 100% correct for each quarter, but the grand total value is not correct year wise. Please help on this, how to solve these production issue. Thanks is advance.
Note :- These issue for all year, there is decimal point error.
Attached : - Screenshot of the graphs/Table and used formula to find the value.
Year 2020= it shoud be grand total= 450.558 but in pivot table it is 435.32
Handheld = (SUMX(DISTINCT(Output[Dollars (US $ M)]),Output[Dollars (US $ M)]))/1000
Regards,
Krishna
1 Reply
- lbendlin
Super User
Remove the DISTINCT() part.