Forum Discussion
JAGA123
2 years agoFrequent Visitor
Grand total is not correct
hi, can possible to help me. this Total is not correct.
- 2 years ago
Hi JAGA123 ,
Please use in this case SUMX:
SUMX( table[column] , [Qty]*[Rate] )Please check also this article:
Obtaining accurate totals in DAX - SQLBI
lkalawski
Resident Rockstar
2 years agoHi JAGA123 ,
Please use in this case SUMX:
SUMX(
table[column]
, [Qty]*[Rate]
)Please check also this article:
Obtaining accurate totals in DAX - SQLBI