In this Video, I’ll create a DAX (Data Analysis eXpression) function to create a Measure. DAX can be used in Microsoft Power BI, Microsoft PowerPivot, and MDX. It’s a relatively easy way to model your data.
Today’s DAX Expression:
Gross Margin % := SUM(‘Sales Line Items'[Gross Margin]) / SUM(‘Sales Line Items'[Total Sales])
Blog Syndicated with Belinda Allen’s Permission