CALCULATE Average depends on Date selected

[adarshashrestha]

Hi,

I am trying to calculate Average in using Measure but not able to get the average with certain date selected.

For eg:

Date               Sales
6/1/2021        5465
6/2/2021        5658
6/3/2021        5221
6/4/2021        4547
6/5/2021        12
6/6/2021        22256
6/7/2021        22356

Here if I filter just 3 days (1st June to 3rd June) Average = 5448

Same way, if I filter the date from 3rd June to 7th June than Average = 10878.4

Really appreciate for your help.

[adarshashrestha]

Thank you verymuch for your quick reply, Jihwan

But what I need a unique Average value so that I can do further calculation like:

If average > x then Sales/x value (per each row)

How can show in above table Average = 12.292.75 for each row.

[Jihwan_Kim]

https://www.dropbox.com/s/t3gqd6i3hmwom0u/adarshash.pbix?dl=0 

[Jihwan_Kim · Accepted solution]

https://www.dropbox.com/s/t3gqd6i3hmwom0u/adarshash.pbix?dl=0