vanderbNew Member2 years agoSolvedTotal incorrect Hi all, I'm new to Power BI and DAX and have bit of an issue with the DAX totals. Is anyone able to help me please? I'm expecting the total to be 15.7m like I see in Excel but in Power BI I get infl...Show MoreVillyMBI2 years agoHi vanderb ,The total of the table visual also calculated with the measure and so you are getting 60 Mas 3855.55 * 15700 = 60532135.Please try using below dax for SalesSales = SUMX('Your table', [Qty] * [Cost])I hope this will help you 🙂
VillyMBI2 years agoHi vanderb ,The total of the table visual also calculated with the measure and so you are getting 60 Mas 3855.55 * 15700 = 60532135.Please try using below dax for SalesSales = SUMX('Your table', [Qty] * [Cost])I hope this will help you 🙂
VillyMBI2 years agoHi vanderb ,The total of the table visual also calculated with the measure and so you are getting 60 Mas 3855.55 * 15700 = 60532135.Please try using below dax for SalesSales = SUMX('Your table', [Qty] * [Cost])I hope this will help you 🙂
VillyMBIResolver I2 years agoHi vanderb ,The total of the table visual also calculated with the measure and so you are getting 60 Mas 3855.55 * 15700 = 60532135.Please try using below dax for SalesSales = SUMX('Your table', [Qty] * [Cost])I hope this will help you 🙂
Related contentIncorrect turnover totalMeasure Total IncorrectMatrix Totals IncorrectIncorrect totalIncorrect Total
