Date slicer

[Anonymous]

Hi, 

I have created a month slicer for my data and it works just fine when viewing a single month of data. However, when I select multiple months or select the 'select all' option, the values returned in the visuals are the sums of the data, rather than the average.

Is it possible to get my model to display the average of the data when I select multiple months instead of displaying the sum of them?

Thanks in advance.

[V-lianl-msft]

Hi @Anonymous ,

Create a measure like this:

Measure = AVERAGE('Table'[value])

If the problem persists,could you share more details to let the scenario more clear ?

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak · Accepted solution]

@Anonymous , Try like given examples. The second one should work

Average(Table[Value])

Or
AverageX(values(Table[Month Year]),sum(Table[Value]))

[Anonymous]

Thanks! the first solution worked. Seems like it was an easy fix.