In this Video, I’ll create a DAX (Data Analysis eXpression) Measure. This measure creates the Salesperson Commission amount. To achieve this, I’ll have to multiply two fields together that reside in different queries.
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:
Commission := SUMX(‘Sales Line Items’, ‘Sales Line Items'[Total Sales] * RELATED(Salesperson[Commission Percent]))