Forum Discussion

MSAYED26's avatar
MSAYED26
Icon for Helper II rankHelper 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 Proces...
'Need help' 'DAX'
  • Greg_Deckler's avatar
    Greg_Deckler
    2 years ago

    MSAYED26 Try:

    AVERAGEX(ALL('Total Mechanical Process core'),'Total Mechanical Process core'[Value])
MSAYED26's avatar
MSAYED26
Icon for Helper II rankHelper II
2 years ago

Thank it work , but i want iteractive values with slicer 

 

Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
2 years ago

MSAYED26 Use ALLSELECTED instead of ALL.