Forum Discussion

Miro's avatar
Miro
Icon for Advocate I rankAdvocate I
3 years ago
Solved

Average pro date selected

Hello everyone,  I am new to Power BI and fail to figure out something that is supposedly easy. I calculate Average pro tag = AVERAGEX(ALL('Date'[Date]), [Sales]) But then if I chose the date span...
Need Help
  • olgad's avatar
    olgad
    3 years ago

    Hi there,
    Adjust the measure to 

    AVERAGEX(ALLSELECTED('Date'[Date]), [Sales])
    It shall give you what you want. 
olgad's avatar
olgad
Icon for Resident Rockstar rankResident Rockstar
3 years ago

Hi there,
Adjust the measure to 

AVERAGEX(ALLSELECTED('Date'[Date]), [Sales])
It shall give you what you want.