Count of days based on filter for average

[ghamiz]

Hi, i am a newbie in power bi so pardon my ignorance 🙂

I have application wise traffic data since 24-Feb-2020 till 08-Apr-2020 (45 days). An application has sub application so for single day multiple rows per application is possible.

I just want to get daily average traffic of each application based on the selected days in filter. But i am unable to get the days count correctly.

I applied month filter for Apr, there are 8 dates data for April. It is possible that some application might have only 5 days data for April. So i want to return count of days per each application.

I used following formula, but it is returning me 45 for each application, though i've applied Apr filter.

Measure =

var start_Date=FIRSTDATE(ALLSELECTED('App'[Date]))

var end_Date=LASTDATE(ALLSELECTED('App'[Date]))

return

CALCULATE(DATEDIFF(start_Date, end_Date, DAY))

Once i get the correct count of day, I will divide it with sum of traffic to get the average.

any help would be appreciated.

[amitchandak · Accepted solution]

@ghamiz 
The formula and relation has some problem

distinct date use
distinctcount('App'[Date])

[ghamiz]

hey this really worked, how silly of me 😞

thanks for the help

🙂

[Greg_Deckler]

It looks like a relationship is not setup correctly. 

Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490