Forum Discussion
Divide columns from two different tables in calculated column
Hello everyone, I am trying to divide speed with Max speed. I created a measure to calculate speed which works fine. But when I try to divide this measure by its max value, it does not accept the co...
Hi Anonymous ,
I created a sample pbix file(see attachment) for you, please check whether that is what you want. You can create a measure as below to get the Speed2 base on the measure [Speed1] :
Speed2 = VAR _tab = SUMMARIZE ( ALLSELECTED ( 'Table1' ), 'Table1'[ID], "@speed", [Speed1] ) VAR _maxspeed = MAXX ( _tab, [@speed] ) RETURN DIVIDE ( [Speed1], _maxspeed ) * 100Best Regards
Hi Anonymous ,
I created a sample pbix file(see attachment) for you, please check whether that is what you want. You can create a measure as below to get the Speed2 base on the measure [Speed1] :
Speed2 =
VAR _tab =
SUMMARIZE ( ALLSELECTED ( 'Table1' ), 'Table1'[ID], "@speed", [Speed1] )
VAR _maxspeed =
MAXX ( _tab, [@speed] )
RETURN
DIVIDE ( [Speed1], _maxspeed ) * 100
Best Regards