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)

 

Using Divide in a DAX Measures in Microsoft Power BI

Blog Syndicated with Belinda Allen’s Permission

Author: Belinda Allen

A (Microsoft) MVP/MCP/MCT and Business Intelligence Program Manager at http://www.Njevity.com , Microsoft Dynamics GP.

Share This Post On