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 ret...
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]))

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.