Forum Discussion
Solved
Average
Hi! I have a model with the next table (this is a small sample of a much larger base) Name Year Month Review Count Weight Name1 2021 1 A1 4 10 Name1 2021 1 A1 1 60 Nam...
The reason it's giving this is that you are averaging at the table row granularity. That is, averaging these values:
To fix this, you need to average over the appropriate granularity:
avg = AVERAGEX ( SUMMARIZE ( Peso, Peso[Name], Peso[Review] ), [aux2] )
The reason it's giving this is that you are averaging at the table row granularity. That is, averaging these values:
To fix this, you need to average over the appropriate granularity:
avg = AVERAGEX ( SUMMARIZE ( Peso, Peso[Name], Peso[Review] ), [aux2] )