Forum Discussion

Icon for Helper III rank

Helper III

8 years ago

Average by ID

Hello All! It seems like very easy but I'm having trouble with it. OBS: I'm getting the data by live concection( Importing dataset from power BI online) The table I have ID Va...

Icon for Helper III rank

Helper III

8 years ago

Thank you for the answers,

parry2k is returning by ID but the average isn't right...

danextian is returning the right average but it isn't by ID...

I'll look where I can put both answers together to solve this issue.

Thanks,

Best Regards,

Diego

parry2k
Super User
8 years ago
sirros_iotif you put Id and this new measure in a table view, I expect the result to be correct. Could you share what result you are getting? Why it is not correct?
- Sean
  Community Champion
  8 years ago
  sirros_iot
  This should do it (and should work as a column too)
  
  Measure = CALCULATE ( AVERAGE ( Table1[Value] ), ALLEXCEPT ( Table1, Table1[ID] ) )
  
  parry2k's solution works too.
  But why write so much? :smileyvery-happy:
  - sirros_iot
    Helper III
    8 years ago
    Hello all! The filter by ID is working!
    
    I think I know the problem about that measure that was calculating by ID right... I have page filters that take out some data.
    
    I would have to filter this measure, when I tried to do it, it stop working right.
    
    Exemple of the measure... and my table... ID = sensor The correct answer for .Avg would be 8.625
    .Avg = CALCULATE ( AVERAGE ( RealTimeData[intervalo] ); ALLEXCEPT ( RealTimeData; RealTimeData[sensor] ))]
    
    I would like to do something lke this..
    .Avg = CALCULATE ( AVERAGE ( RealTimeData[intervalo] ); ALLEXCEPT ( RealTimeData; RealTimeData[sensor] ); FILTER( RealTimeData; RealTimeData[contagem] > 1))
    But it returns me...
    
    Sorry anything, Sean, parry2k, danextian
    Best Regards,
    Diego