First value or Max.....

[Anonymous]

I have three columns, "Part Number", "Fixed Rate" and "Non-Fixed Rate".  There will be either a value, greater than 0, in "Fixed Rate" or "Non-Fixed Rate".  There will never be a value greater than 0 in both.

Part_Number      Fixed_Rate     Non-Fixed_Rate          Measure Value

CH 1234              0                    125.00                         187.50

CH 2345              100.00            0                                 150.00

CH 3456              0                     150.00                        225.00

I need a measure that will look at both columns, pull the one value it finds greater than 0, and times it by 1.5.

In excel, it would look like this.

=max(B2,C2)*1.5

[Anonymous · Accepted solution]

I think I found the answer.  This looks like it is working correctly.

Measure = MAXX(Pricing,max(Pricing[Standard Aero Fixed Flat Rate],Pricing[Standard Aero Non-Fixed Flat Rate]))*1.5