Measure to SUM and discount Column2 based on the data in Column1

[jgpbi]

I need a measurement that sums Column2 and multplies is by 1 if the value in Column1 equals "Test" otherwise multiply is by 0.93. Essentially, I need a 7% discount if Column1 doesn't say "Test" and a 0% discount is it does equals exactly "Test". My results are wildly incorrect and I can't see why.

I have tried this....

What math am I missing here?

The results should be

.93

.93

100

93

93

[Anonymous]

Hi @jgpbi ,

I'm very happy that your problem has been solved. Could you please accept your own answer as the solution?

Thank you and I wish you a happy life.

Best Regards,
Yang
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

[jgpbi · Accepted solution]

Solution - I was summing the whole column not just the row. Needed an IF

Here is the solution.

Column 2 = IF ( 'Table'[Column1] = "Test", 'Table'[Column2], 'Table'[Column2] * 0.93 )