Not sure if I understood fully but you can write below calculation & apply same for the others
Drag this to filter set as True.
When I select Ujjaini....then it will show average for that parameter value only
For date you can use below calculation & set again as true
Please find the attached workbook.
Please mark it as CORRECT & HELPFUL if it really helped you so that it can help others as well
Event and Non event.twbx 261.0 KB