New to DAX and PowerBI - Trying to visualize daily average ticket amounts

[jbrandRPA]

I have a table with a list of tickets (transactions), date started, and amount.  I've already created a measure for average ticket amount for the entire table, but now I want to calculate the average per day so that i can show it on a graph

[v-danhe-msft]

Hi @jbrandRPA,

If I understand correctly, you could refer to below formula:

Measure = CALCULATE(SUM(Yourtable name[Amount]))/CALCULATE(COUNT(Yourtable name[Day]))

Regards,

Daniel He

[Greg_Deckler]

Take a look at these two Quick Measures as I think you want something like them.

https://community.powerbi.com/t5/Quick-Measures-Gallery/Open-Tickets/m-p/409364
https://community.powerbi.com/t5/Quick-Measures-Gallery/Periodic-Billing/m-p/409365