Forum Discussion

sirros_iot's avatar
sirros_iot
Icon for Helper III rankHelper 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...
Need Help
parry2k's avatar
parry2k
Icon for Super User rankSuper 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's avatar
Sean
Icon for Community Champion rankCommunity 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's avatar
    sirros_iot
    Icon for Helper III rankHelper 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

    • sirros_iot's avatar
      sirros_iot
      Icon for Helper III rankHelper III
      8 years ago

      I just saw that in the total I have the correct answer!

      Someone knows what is the problem?

       

      Thanks,

      Diego