Value relative to max

[AviramWeiss]

Hello everyone,

I'm struggling with a Radar Chart, trying to use it to show multiple parameters of a chosen branch (among other filters).

Due to the nature of this visual, I had to turture my data to such a structure:

Branch	Parameter	Value
A	Income	100
A	Cost	50
A	Workers	3
B	Income	200
B	Cost	70
B	Workers	5

After applying a Branch filter (for the entire page), I wanted to show all parameters on a single Radar Chart (there are more than 3 params).

However, since each param has its own range, they're not presented well on the chart.

So I thought of "rectifying" them, relative to the max branch. In this manner, Income would be divided by 200, Cost by 70 and Workers by 5, and all will be on a scale between 0 and 1.

I tried to do that with measures using Calculate(Maxx()), or Maxx(Calculatetable(Groupby())), but failed.

Any ideas would be warmly welcomed.

Thank you,

Aviram

[smpa01]

@AviramWeiss   are you looking for a measure like this?

Measure = 
VAR maxByParameterIgnoringFilter =
    CALCULATE (
        MAX ( 'Table'[Value    ] ),
        INDEX (
            1,
            DISTINCT ( ALL ( 'Table' ) ),
            ORDERBY ( 'Table'[Value    ], DESC ),
            KEEP,
            PARTITIONBY ( 'Table'[Parameter     ] )
        )
    )
VAR curr =
    MAX ( 'Table'[Value    ] )
RETURN
    DIVIDE ( curr, maxByParameterIgnoringFilter )

[AviramWeiss]

Thank you very much, @smpa01 ,

I'm probably using a too old version of Power BI (2.88.2361.0), and cannot upgrade, due to corporate regulation, but I can't find "Index" as a function in DAX.

Thus, can't try you suggested solution.