Total not showing in table visual

Hi sudhanshu45 ,
Thanks for sharing the details. The issue is happening because your two columns come from different tables with a many-to-one relationship. In this scenario, a raw column from the one side (Discount) cannot automatically compute row level values and totals correctly in the table visual.

The recommended approach is to create a DAX measure that handles both row level and total calculations. Here’s a working example I have tried :

DiscountPerOrder =
IF(
HASONEVALUE(SalesOrderTable[SalesOrderNumber]),
LOOKUPVALUE(
DiscountTable[DiscountAmount],
DiscountTable[SalesOrderNumber],
VALUES(SalesOrderTable[SalesOrderNumber])
),
SUMX(
SalesOrderTable,
LOOKUPVALUE(
DiscountTable[DiscountAmount],
DiscountTable[SalesOrderNumber],
SalesOrderTable[SalesOrderNumber]
)
)
)
This approach ensures proper row-level values and accurate totals even when the columns come from different tables in a many-to-one relationship.

Please find the attached .pbix file for your reference.