Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

How to create measures that keep steady value

I am working on creating a control chart to show average cost each month in the past 12 months. I have created a Line Chart visual with month on the x-axis and average cost per month on the y-axis. O...
Need Help
  • MFelix's avatar
    MFelix
    6 years ago
    Hi Anonymous,

    You need to do a measure similar to this

    Total average = CALCULATE (AVERAGE(Table[Total Cost]) ; ALL(Table[Month]))
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi Anonymous ,

 

Please refer to the measure below.

Measure = CALCULATE(AVERAGE('Table'[Total Cost]),ALLEXCEPT('Table','Table'[ Year],'Table'[Month]))

 

Best Regards,

Jay

Community Support Team _ Jay Wang

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