Forum Discussion
Divide Measure by its Max value
I have two tables. They are related to each other on ID. I want to calculate - Final Speed which is = Speed Measure/max (Speed Measure) But I am unable to do so. It is not recognising ...
Hi Anonymous ,
How about this:
ID 11 has the maximum speed, which is why the measure shows 1.
This is the measure I used:
Speed 1 mes = VAR _helpTable = SUMMARIZE ( ALLSELECTED ( Table2 ), [ID], "speed", [speed1] ) VAR _maxSpeed = CALCULATE ( MAXX ( _helpTable , [speed] ) ) RETURN DIVIDE ( Table2[Speed1], _maxSpeed )Hope this is it!
/Tom
https://www.instagram.com/tackytechtom
Hi Anonymous ,
How about this:
ID 11 has the maximum speed, which is why the measure shows 1.
This is the measure I used:
Speed 1 mes =
VAR _helpTable =
SUMMARIZE (
ALLSELECTED ( Table2 ),
[ID],
"speed", [speed1]
)
VAR _maxSpeed = CALCULATE ( MAXX ( _helpTable , [speed] ) )
RETURN
DIVIDE ( Table2[Speed1], _maxSpeed )
Hope this is it!
/Tom
https://www.instagram.com/tackytechtom
Hi Anonymous ,
It seems like you are using the ID column from table1. Try using it from table2 instead.
/Tom