cancel
Showing results for
Did you mean:

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Helper I

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

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!

Example data:

1 ACCEPTED SOLUTION
Super User

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

Luca D'Elicio
Super User

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

Luca D'Elicio

Announcements

Fabric certifications survey

Certification feedback opportunity for the community.

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors