Forum Discussion
MSAYED26
2 years agoHelper II
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...
Greg_Deckler
2 years agoCommunity Champion
MSAYED26 Try:
AVERAGEX(ALL('Total Mechanical Process core'),'Total Mechanical Process core'[Value])MSAYED26
2 years agoHelper II
Thank it work , but i want iteractive values with slicer
- Greg_Deckler2 years agoCommunity Champion
MSAYED26 Use ALLSELECTED instead of ALL.