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.