Forum Discussion
ebecerra
Microsoft Employee
Microsoft EmployeeGraphing weighted average by day
I'm having a problem trying to graph the weighted average of my data. I've already tried to look in the forums for similar scenarios but didn't really find anything that I could use as baseline. Let ...
There shouldn't be any need to use ALLSELECTED in your Wavg measure.
The denominator should be simply the sum of Session Count in the current filter context.
Try this:
Wavg = DIVIDE ( SUMX ( 'Table', 'Table'[Score] * 'Table'[Session Count] ), SUM ( 'Table'[Session Count] ) )This should give the correct weighted average whether filtered by Date or anything else.
Does this give the correct result?
Regards,
Owen
OwenAuger
Super User
Super UserThere shouldn't be any need to use ALLSELECTED in your Wavg measure.
The denominator should be simply the sum of Session Count in the current filter context.
Try this:
Wavg =
DIVIDE (
SUMX ( 'Table', 'Table'[Score] * 'Table'[Session Count] ),
SUM ( 'Table'[Session Count] )
)
This should give the correct weighted average whether filtered by Date or anything else.
Does this give the correct result?
Regards,
Owen