Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Multiplication with measure

Hi all,   I want to do a multiplication which looks like this:   TimeDifference * SpeedM/S   // TimeDifference =Max(Table1[TIME]) - MIN(Table1[TIME]) // TIME = a Calculated column SpeedM/S = ...
Need Help
  • Anonymous's avatar
    Anonymous
    8 years ago

    Anonymous,

    In your table, you have different SpeedM/S for different Stationary Objects. You would need to create a measure to calculate a average speed value, then calculate distance between objects.

    TimeDifference = MAX(Table1[time])-MIN(Table1[time])

    AverageSpeed = AVERAGE(Table1[SpeedM/S])

    OutputMeasure = [TimeDifference]*[AverageSpeed]

    Regards,
    Lydia

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Anonymous,

Create a calculated column using the formula below.
Column = MINUTE(Table1[Time])*60+SECOND(Table1[Time])

Then create the following measures in your table.
TimeDifference = Max(Table1[Column])- MIN(Table1[Column])
OutputMeasure = [TimeDifference]*VALUES(Table1[SpeedMS])


Regards,
Lydia

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Hi Anonymous rcspaiva bsas,

 

I followed the exact steps and the measure that turns time into seconds as a number works perfectly, the problem I have now is that the "outputmeasure" in Anonymous gives the following error when I try to display it in a visual:

 

"Calculation error in measure [outputmeasure]: A table of multiple values was supplied where a single value was expected"

 

the measure itself works but I can't get it to display something ..

 

Regards, L.Meijdam (excuses for the late response)