Average by ID

Question

Hello All!&nbsp;It seems like very easy but I'm having trouble with it. OBS: I'm getting the data by&nbsp;live concection(&nbsp;Importing dataset from power BI online)The table I haveID&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Value&nbsp; &nbsp;1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 52&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 21&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 32&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 6&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;What I want with the measureID&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Value&nbsp; &nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; measure1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 5&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 42&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 51&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 3&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 42&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 8&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 5I tried to use quick measures but It didn't return me te right thing&nbsp;Best Regards,Diego&nbsp;

sean · Answer

sirros_iotThis should do it (and should work as a column too)&nbsp;Measure =
CALCULATE ( AVERAGE ( Table1[Value] ), ALLEXCEPT ( Table1, Table1[ID] ) )&nbsp;parry2k's solution works too.But why write so much? :smileyvery-happy:

parry2k · Answer

You need to add a measure to something like this&nbsp;Measure = var m = FIRSTNONBLANK(Table1[id], "") return CALCULATE(AVERAGE(Table1[value]), FILTER(ALLSELECTED(Table1),m =Table1[id]))

danextian · Answer

Hi&nbsp;sirros_iot,&nbsp;Try this:&nbsp;avg by id =CALCULATE ( AVERAGEX ( ALL ( 'Table'[ID] ), AVERAGE ( 'Table'[Value] ) ), ALLEXCEPT ( 'Table', 'Table'[ID] ))

parry2k · Answer

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?

sirros_iot · Answer

Thank you for the answers,parry2k&nbsp;is returning by ID but the average isn't right...danextian&nbsp;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

Forum Discussion

Average by ID

7 Replies

Related content

Average and Moving Average

Weekly Average

Accumulated average

moving average help

Average of Average Pattern Inaccuracies