Calculates percentages based on the maximum value of the sum of a row

[Syndicate_Admin]

Good day, I write this question again but with fictitious values as requested

What I need is to create a measure to calculate the % of each vehicle in relation to the maximum value of that column.

In other words, the Chevrolet Onix Hatch would correspond to 100%, the EcoSport would correspond (958.43 / 51268.52) and thus calculate the percentages for each vehicle. In other words, let it look something like this:

Best regards

[Barthel · Accepted solution]

Hey @Syndicate_Admin, 
Give this a try:

Measure = 
VAR _max =
    CALCULATE ( 
        MAX ( 'Table'[Suma Precio] ),
        REMOVEFILTERS ( 'Table'[Vehiculo] )
    )
VAR _result =
    DIVIDE ( SELECTEDVALUE ( 'Table'[Suma Precio] ), _max )
RETURN
    _result

You calculate the maximum by removing the filter context from vehicle. You then use this maximum to calculate the ratio.

[VigneshSub · Accepted solution]

Hi ,
Please use following measure 

% Of Max =

var _max_price = CALCULATE(MAX('Table'[Price]),ALL('Table'[Vehicle]))

return

DIVIDE(SUM('Table'[Price]),_max_price)

[Barthel · Accepted solution]

Hey @Syndicate_Admin, 
Give this a try:

Measure = 
VAR _max =
    CALCULATE ( 
        MAX ( 'Table'[Suma Precio] ),
        REMOVEFILTERS ( 'Table'[Vehiculo] )
    )
VAR _result =
    DIVIDE ( SELECTEDVALUE ( 'Table'[Suma Precio] ), _max )
RETURN
    _result

You calculate the maximum by removing the filter context from vehicle. You then use this maximum to calculate the ratio.