Average number of tickets per day

[Anonymous]

Hi All,

I'd like to graph the average number of tickets by weekday over each week

 Date ,    number of tickets ,                             AVG

01-01 ,                 20     ,                                    20

02-01 ,                 30     ,                                    25

03-01 ,                 25     ,                                    25

04-01 ,                 40     ,                                    28,75

[v-alq-msft · Accepted solution]

Hi, @Anonymous 

Based on your description, I created data to reproduce your scenario.

Test:

You may create a measure as below.

AVG = 
var _date = SELECTEDVALUE('Test'[Date])
return
AVERAGEX(
    FILTER(
        ALLSELECTED(Test),
        Test[Date]<=_date
    ),
    Test[num of tickets]
)

Result:

Best Regards

Allan

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

I found the solution for this matter 🙂 Thank you very much for your supporting 🙂

AVG =

var _date = SELECTEDVALUE(Tickets[Creatietijd])

return

AVERAGEX(

SUMMARIZE (

FILTER(

ALLSELECTED('Tickets');

'Tickets'[Creatietijd] <= _date

);

Tickets[Creatietijd]

);

Tickets[Total Tickets]

)

[Anonymous]

I am getting this results.

Do you know what is going wrong here?

[Anonymous]

@Anonymous Replace semicolon with comma. 

[Anonymous]

I did, but I am getting the same result

[Anonymous]

Hi @v-alq-msft  When I execute this measure I am getting the following result:

AVG =

var _date = SELECTEDVALUE('Tickets'[Creatietijd])

return

AVERAGEX(

FILTER(

ALLSELECTED(Tickets);

Tickets[Creatietijd] <=_date

);

Tickets[Total Calls] (this is a measure)

)

[amitchandak]

In case you want daily Avg to reset at week. Then look at WTD in the given file and use Average Aggregation.

If you are looking for weekly Avg Then use like

 CALCULATE(Average(Sales[Net Sales]),FILTER(all('Date'), 'Date'[Week Rank]<=max('Date'[Week Rank])))

https://www.dropbox.com/s/d9898a48e76wmvl/sales_analytics_weekWise.pbix?dl=0