Forum Discussion

MSAYED26's avatar
MSAYED26
Helper II
2 years ago
Solved

Dax

I want to calculate average for all month ,I want The trend line change every month based on data , used 

AVERAGE CASES = CALCULATE(AVERAGEX('Total Mechanical Process core','Total Mechanical Process core'[Value]),ALL('Total Mechanical Process core'[Column].[Month])) but not working

 

 

'Need help' 'DAX'

3 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion
    2 years ago

    MSAYED26 Try:

    AVERAGEX(ALL('Total Mechanical Process core'),'Total Mechanical Process core'[Value])