Forum Discussion

Miro's avatar
Miro
Advocate 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. 
Miro's avatar
Miro
Advocate I
3 years ago

Thanks, 
it did.