Forum Discussion

CoopyJoe's avatar
CoopyJoe
Frequent Visitor
4 years ago
Solved

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 ...
Need Help
Tips and Tricks
  • v-xiaotang's avatar
    v-xiaotang
    4 years ago

    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.

AlexisOlson's avatar
AlexisOlson
Icon for Super User rankSuper User
4 years ago

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.