Using Divide in a DAX Measures in Microsoft Power BI

In this Video, I’ll create a DAX (Data Analysis eXpression) function (Divide) to alter 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 % := DIVIDE(SUM(‘Sales Line Items'[Gross Margin]), SUM(‘Sales Line Items'[Total Sales]), 0)


Leave a Reply