S03.M04.L07.D01 - not existing [Cost Amount] is used instead of [Total Cost]
EVALUATE
SUMMARIZECOLUMNS (
'Product'[Brand],
"Margin %",
[Sales Amount] / [Cost Amount]
)
In book [Total Amount] is used, but I'm guessing this is a mistake as well. It should be [Total Cost].
S03.M04.L07.D01 - not existing [Cost Amount] is used instead of [Total Cost]
EVALUATE
SUMMARIZECOLUMNS (
'Product'[Brand],
"Margin %",
[Sales Amount] / [Cost Amount]
)
In book [Total Amount] is used, but I'm guessing this is a mistake as well. It should be [Total Cost].