cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Usates Member
Member

First value or Max.....

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

1 ACCEPTED SOLUTION

Accepted Solutions
Usates Member
Member

Re: First value or Max.....

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

1 REPLY 1
Usates Member
Member

Re: First value or Max.....

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