Need help calculating SUM of values per day divided by value assigned to that day. Example provided.

[The_Clam]

Hello! I need to divide the Sum of "Count Affected" for each day by the "Total Count" assigned to that day (NOT the sum). In the provided Power BI example: The date 3/6/2021 has two records. So the formula would be (31 + 23) / 2521 (NOT 2521 + 2521).

Then I need to find the average of that calculated data for the year 2021 and the year 2022.

Thank you!

Power BI link:

https://drive.google.com/file/d/11u15VNzscn_Z_cAd9WMRqRtnwqT5X_rp/view?usp=sharing

Example data:

[lucadelicio · Accepted solution]

Measure = SUM(data[Count Affected]) / AVERAGE(data[Total Count])
Remove the id from the column in the table result:

Mark as solution if i help you