Logic to restrict max number

[sdhn]

Hi there,

I am rewriting my message with current status.

I have a working messure as below:

Working % =

VAR _Ratio =

DIVIDE (

SUM ( 'Table'[Col 1] ) + SUM ( 'Table'[Col 2] ),

SUM ( 'Table'[Col 3] )

)

RETURN

MIN ( _Ratio, 1 )

 Outcome:

Any product percentage over 100 % or  equal to 100 % will display s as 100 %.  No changes in the lower numbers. such as 67 % would be 67 %.

Now I need to write code base on 2 columns (Col 2, Col 3 from above)  from the same table above. Need to write similar logic.

Instead of third column I used number "1". 

Not Working  % =
VAR _Ratio =
DIVIDE (
SUM ( 'Table'[Col. 2 ) + SUM ( 'Table'[Col 3] ), (1)
)
RETURN
MIN ( _Ratio, 1 )

OUTCOME

All values of product are dispalying as 100%.

   Help will be appreciated. 

[Icey]

Hi @sdhn ,

I have the same doubt as @AlexisOlson : Why do you divide by 1 in the "Not Working" measure?

---

Not Working  % =
VAR _Ratio =
DIVIDE (
SUM ( 'Table'[Col. 2 ) + SUM ( 'Table'[Col 3] ), (1)
)
RETURN
MIN ( _Ratio, 1 )

---

What do the two columns represent? What is your calculation logic?

Best Regards,

Icey

[sdhn]

without DIVIDE option

Not Working  % =
VAR _Ratio =
(
SUM ( 'Table'[Col. 2 ) + SUM ( 'Table'[Col 3] ), (1)
)
RETURN
MIN ( _Ratio, 1 )

OUTCOME
ALL Products is displaying as 100 %

[sdhn]

without RATIO, 

Not Working  % =  SUM ( 'Table'[Col. 2 ) + SUM ( 'Table'[Col 3] ), (1)

OUTCOME:

getting very large values

[sdhn]

Below

[AlexisOlson]

I don't follow what the ratio is intended to be in the second example. Why are you dividing by 1?

[sdhn]

I do not have an answer.  Just trying to copy working code. (First one)

Any product over 100 % must shows as 100 %. Also 100 must display as 100 too.  

Rest same as they are.   Thanks

[AlexisOlson]

It's not easy to answer a question based on what you don't want. What result do you want?

Why are the results you're getting not correct? How do you know they're not correct if you don't know what they should be? What do you expect to get if things work properly?