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

#### New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

#### Fabric Monthly Update - May 2024

Check out the May 2024 Fabric update to learn about new features.

#### Fabric certifications survey

Certification feedback opportunity for the community.

Top Solution Authors
Top Kudoed Authors