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
I am not sure what the ID in your model does, so it might work if you remove the 'Table'[ID] in the SUMMARIZE function. Otherwise, you are welcome to share some data and show a possible outcome of what you would like to achieve 🙂
/Tom