Dax

[MSAYED26]

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

 

[Greg_Deckler · Accepted solution]

@MSAYED26 Try:

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

[Greg_Deckler · Accepted solution]

@MSAYED26 Try:

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

[MSAYED26]

Thank it work , but i want iteractive values with slicer 

[Greg_Deckler · Accepted solution]

@MSAYED26 Use ALLSELECTED instead of ALL.