CODEWITHSUNDEEP
powerbidax
number 5
number 5

Reputation: 15

Power Bi DAX Avg

I have 2 columns and I am trying to get the average of step counts per id in a power bi measure. Would be great if someone faced a scenario like this and shed some light on it.

enter image description here

Should be giving me "avg. 9"

Upvotes: 0

Views: 47

Answers (1)

number 5
number 5

Reputation: 15

Trying AvgStepsById = AVERAGEX(VALUES(Table[id]),CALCULATE(MAX(Table[step count]))) worked! Thank you Stachu

Upvotes: 0

Related Questions