Using Divide in a DAX Measures in Microsoft Power BI

Belinda AllenDyn365GP6 years ago107 Views

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

0 Votes: 0 Upvotes, 0 Downvotes (0 Points)

Join Us
  • X Network2.1K
  • LinkedIn3.8k
  • Bluesky0.5K
Support The Site
Events
August 2025
MTWTFSS
     1 2 3
4 5 6 7 8 9 10
11 12 13 14 15 16 17
18 19 20 21 22 23 24
25 26 27 28 29 30 31
« Jul   Sep »
Follow
Search
Popular Now
Loading

Signing-in 3 seconds...

Signing-up 3 seconds...