Calculated Column Value Result Repeating

[CoopyJoe]

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!

[v-xiaotang · Accepted solution]

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.

[Ashish_Mathur]

Hi,

Write that formula as a calculated column formula (not a measure)

[AlexisOlson]

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.

[ribisht17]

@CoopyJoe 

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 Users 

[CoopyJoe]

@HenriqueReis yes, they are both correct.

[HenriqueReis]

Hi,

The type of the columns are correct? (number)