Forum Discussion
How To Get *Actual* Average
I have this table: So on the far right column, I'm trying to get the average deal size based on the sum column. By default, PBI is taking $312,994.57 and dividing it by 423 (the number o...
Can you try this? I think it shoud work
AVERAGEX( Values( Table[Producer]), //be sure to change to the appropriate table [column] [ Your Sum Measure Here] )
Can you try this? I think it shoud work
AVERAGEX(
Values( Table[Producer]), //be sure to change to the appropriate table [column]
[ Your Sum Measure Here]
)