I am attempting to create a table that has a dimension of 'Event Date' and 10 expressions that are all similarly structured.
My end goal is to have a value that is the price per ticket paid, based on the total sale divided by the total quantity sold.
My initial expression is: =NUM(avg({$<PRICESCALE={"200 Club End"}>}[TOTALSALE]), '$#,###.') which is giving me the average price of the 'TOTALSALE' when the 'PRICESCALE' is 200 Club End. However, I need to introduce the following count(seatnumber) to divide by the initial expression to result in the average price paid
