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   12005 109% 12652 115% 13258 120%  ...
  • parry2k's avatar
    6 years ago

    Suryaann add following measure

     

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