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, like in the snapshot, it shall be the average of 2 million somewhat, how do I get that number?


Thanks in advance for your help. 

 

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. 

2 Replies

  • olgad's avatar
    olgad
    Resident Rockstar
    3 years ago

    Hi there,
    Adjust the measure to 

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