SalesAmount = Sales[Quantity]*Sales[Net Price] Sales Amount = SUMX ( Sales, Sales[Quantity] * Sales[Net Price] ) Total Cost = Sales[Quantity]*Sales[Unit Cost] Total Cost = SUMX(Sales, Sales[Quantity]*Sales[Unit Cost]) Gross Margin = Sales[Sales Amount]-Sales[Total Cost] Gross Margin % = DIVIDE([Gross Margin], Sales[Sales Amount]) All Sales Amount = SUMX ( ALL ( Sales ), Sales[Quantity] * Sales[Net Price] ) RedSales = SUMX ( FILTER ( Sales, RELATED ( 'Product'[Color] ) = "Red" ), Sales[Quantity] * Sales[Net Price] ) DiscountStatus = IF(Sales[Unit Discount]>0,"Discounted","NOT Discounted")