Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 like to multiple _omiPercentage with ompOrderTotalBase. The fields are located in two different tables. As you can see below the correct value is used for SO Total 2 rows but the Total is not correct.
What is the correct expression to use for this case. Any assistance is greatly appreciated!
Thanks in advance,
Jeff
Solved! Go to Solution.
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.
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!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
99 | |
98 | |
80 | |
76 | |
66 |
User | Count |
---|---|
136 | |
109 | |
104 | |
82 | |
73 |