cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
MarkRIRL
Regular Visitor

Calculate percentage difference in columns

Hi, 

 

I'm a novice Power BI user trying to upskill, and was hoping for some help after hours of no progress. 🙂 I have a table that contains three rows. Course Title, Total Number in Course, and Number Completed.

 

I am trying to create the last column, Percentage Complete

 

Annotation 2020-07-17 161542.png

 


The data for column 2 and 3 comes from different tables, Student Records, and Survey. The common item for the relationship is course title.   I don't know do I create a Measure, quick measure, table, or maybe case some chicken bones. 

 

 Any help or links would be greatly appreaciated.

 

Thanks

1 ACCEPTED SOLUTION
parry2k
Super User
Super User

@MarkRIRL it is pretty straight forward, the key part is how these tables are connected.

 

Total Course = COUNTROWS ( TableCourse )

Number Completed = SUM ( TableCompleted[Completed] ) 

or

Number Completed = COUNTROWS ( TableCompleted )

Percent Complete = DIVIDE ( [Number Completed], [Total Course] ) 

 

add above measure, in table visual, add course column from the common table and add above measures

 

I would  Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!

Visit us at https://perytus.com, your one-stop shop for Power BI related projects/training/consultancy.

 






Did I answer your question? Mark my post as a solution.

Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.





View solution in original post

3 REPLIES 3
DataZoe
Super User
Super User

@MarkRIRL You can create a measure from the ribbon, or right-clicking the table name and choosing "New Measure". You can try this:

 

Percentage Complete =
DIVIDE (
    SUM ( 'Table'[Number completed] ),
    SUM ( 'Table'[total Number in Course] )
)

 

Measure.gif

 

 

Respectfully,
DataZoe


See my reports and blog at https://www.datazoepowerbi.com/

Thank you both so much. Betwen your two answers I was able to get what I wanted. Below is what worked for me. I thought I had down something wrong, until I realized I just needed to add some decimal places.

 

Percentage Complete =
DIVIDE (
COUNT ( 'Survey'[Student ID] ),
Count ( 'Student Records'[Student ID] )
)
parry2k
Super User
Super User

@MarkRIRL it is pretty straight forward, the key part is how these tables are connected.

 

Total Course = COUNTROWS ( TableCourse )

Number Completed = SUM ( TableCompleted[Completed] ) 

or

Number Completed = COUNTROWS ( TableCompleted )

Percent Complete = DIVIDE ( [Number Completed], [Total Course] ) 

 

add above measure, in table visual, add course column from the common table and add above measures

 

I would  Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!

Visit us at https://perytus.com, your one-stop shop for Power BI related projects/training/consultancy.

 






Did I answer your question? Mark my post as a solution.

Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.





View solution in original post

Helpful resources

Announcements
PBI_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!