Forum Discussion

Suryaann's avatar
Suryaann
Frequent Visitor
6 years ago
Solved

Minimum value

Hi All,

 

I have scenario to compare the each value with the min value in a column and get the percentage.

 

Value    percentage

 

11025 
12005109%
12652115%
13258120%

 

11025 is the min val.The percentage cal = 12005/(11025-1).

 

Kindly help to get this min value comparison.

Need Help
Show and Tell
Tips and Tricks
  • parry2k's avatar
    parry2k
    6 years ago

    Suryaann add following measure

     

    % of Min Value = 
DIVIDE( 
MAX( Table[Value] ),
CALCULATE( MAX( Table[Value] ), ALL( Table[Value] ) )
)

1 Reply

  • parry2k's avatar
    parry2k
    Super User
    6 years ago

    Suryaann add following measure

     

    % of Min Value = 
DIVIDE( 
MAX( Table[Value] ),
CALCULATE( MAX( Table[Value] ), ALL( Table[Value] ) )
)