Have a calculated field , but need to aggregate

[Anonymous]

I have a calcualtion called ACR

it consists of fields B3 and tickets * 10000

So ACR= b3/tickets * 10000

but if I want to show ACR by day , you can't aggregrate with a sum or average 

how do I show ACR by Day if the data looks like this 

Store    tickets      B3      ACR      Date

4567     305          1         33.0     8/18/2022
4579     401          1          33.0     8/18/2022
4567     383           1        26.0      8/19/2022 
4579     280          1          36.0     8/19/2022

[Anonymous]

Thanks !!! it worked

[tamerj1 · Accepted solution]

Hi @Anonymous 

please try

ACR =

CALCULATE ( [B3] / [Tickets] * 10000, ALLEXCEPT ( 'Table', [Date] )