Forum Discussion
Dax - Multiplying non-aggregate
I need to make a calculation that takes Unit Price * Quantity. factSales has the Quantity field. dimOrder has the UnitPrice field. There is a *:1 relationship setup between them based on OrderNum...
Hi Anonymous
How about you bring the price into the Sales table (possibly with RELATED( )) and then try this measure:
Measure = SUMX(factSales, factSales[UnitPrice]*factSales[Quantity])
Otherwise, share the pbix to see what other options there are.
AlB
Community Champion
Community ChampionHi Anonymous
How about you bring the price into the Sales table (possibly with RELATED( )) and then try this measure:
Measure = SUMX(factSales, factSales[UnitPrice]*factSales[Quantity])
Otherwise, share the pbix to see what other options there are.