Forum Discussion
Solved
DAX Expression for a Simple Calculation
Hi, Sorry for the simple question but I am new to DAX. I am simply trying to multiple two columns from different table but the Total is not computed as expected. From the image below I would li...
jbrinker ,
Suppose the relationship between table 'SalesOrders' and 'SalesOrderSalesPeople' is many to one, you may modify measure using DAX like pattern below and check if the total is correct:
SO Total = SUMX ( 'SalesOrderSalesPeople', [_omiPercentage] * RELATED ( SalesOrders[ompOrderTotalBase] ) )Community Support Team _ Jimmy Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
jbrinker ,
Suppose the relationship between table 'SalesOrders' and 'SalesOrderSalesPeople' is many to one, you may modify measure using DAX like pattern below and check if the total is correct:
SO Total =
SUMX (
'SalesOrderSalesPeople',
[_omiPercentage] * RELATED ( SalesOrders[ompOrderTotalBase] )
)
Community Support Team _ Jimmy Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Perfect. Thanks!
