Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Date slicer

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.

 

 

 

Need Help
  • amitchandak's avatar
    amitchandak
    6 years ago

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

     

    Average(Table[Value])

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

3 Replies

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    6 years ago

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

     

    Average(Table[Value])

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

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

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

  • V-lianl-msft's avatar
    V-lianl-msft
    Icon for Community Support rankCommunity Support
    6 years ago

    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.