Forum Discussion
Calculated Column Value Result Repeating
I am trying to create a calculated column where I simply multiply two values together originating from two different tables. The column should equal $ Adjustment multiplied by Unit Quantity to equal Commisson. My results are repeating rows with the same value, but they should be different. I have attached a screenshot of my DAX formula and the columns I am working with. Thanks!
Hi CoopyJoe
Column expression:
Column = [Adjustment]*RELATED(Table2[Unit Quantity])measure expression:
Commission = [Unit Quantity]*MIN(Commission[Adjustment])Best Regards,
Community Support Team _Tang
If this post helps, please consider Accept it as the solution to help the other members find it more quickly.
6 Replies
Please refer to this one Solved: DAX multiply two columns in separate tables - Microsoft Power BI Community
>>RELATED function
Regards,
Ritesh
Mark my post as a solution if it helped you| Munde and Kudis (Ladies and Gentlemen) I like your Kudos!! !!
My YT Channel Dancing With Data !! Connect on Linkedin !!Power BI for Tableau UsersHi,
The type of the columns are correct? (number)
HenriqueReis yes, they are both correct.
As ribisht17 suggests, the RELATED function is likely useful here. Something like this:
RELATED ( Product[Quantity] ) * Commission[$ Adjustment]This makes some assumptions about how the tables are related though, so I can't guarantee it'll work without seeing how your tables are structured and related to each other.
Hi,
Write that formula as a calculated column formula (not a measure)
Hi CoopyJoe
Column expression:
Column = [Adjustment]*RELATED(Table2[Unit Quantity])measure expression:
Commission = [Unit Quantity]*MIN(Commission[Adjustment])Best Regards,
Community Support Team _Tang
If this post helps, please consider Accept it as the solution to help the other members find it more quickly.
