Forum Discussion
Totals Not adding up correctly
My Power BI table is adding up to wrong total at $9.90. The correct totals should be 8.795, based same data in excel. I am formatted a basic Revenue = SUM(Table[Revenue) measure. Please look my me...
@Syndicate_Admin
If you can share the PBIX, it is much more expeditious to validate and solve your requirement
Please try the following formula.SumTotOk := SUMX( // ------PLEASE CHANGE Table[Company] WITH THE COLUMN ITERATED AT THE VISUAL---------- VALUES( Table[Company] ), CALCULATE( SUMX( Table, [Revenue] ), ALLSELECTED() ) )I hope it is helpful, if so please accept the solution. Kudos are welcome😀
@Syndicate_Admin
Taking the data from the table loaded in power bi, the calculations are correct in the power bi.