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])
Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
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.