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

You need to add a measure to something like this

 

Measure = var m = FIRSTNONBLANK(Table1[id], "") 
return CALCULATE(AVERAGE(Table1[value]), FILTER(ALLSELECTED(Table1),m =Table1[id]))