Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

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

Reply
The_Clam
Helper I
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!

 

Power BI link:

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

 

Example data:

The_Clam_1-1688127404975.png

 

1 ACCEPTED SOLUTION
lucadelicio
Super User
Super User

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

lucadelicio_0-1688127886565.png


Mark as solution if i help you

Luca D'Elicio

View solution in original post

1 REPLY 1
lucadelicio
Super User
Super User

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

lucadelicio_0-1688127886565.png


Mark as solution if i help you

Luca D'Elicio

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

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

April Fabric Community Update

Fabric Community Update - April 2024

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