Assigned Projects, Completed Projects = Column names.Table1 = Excel table name where you are retrieving the data.Apply the below measure to calculate the sum of the assigned project and completed project as shown below:ĪssignedProjects = SUM(Table1) CompletedProjects = SUM(Table1).Click on the new measure from the ribbon to calculate the sum of the assigned project and completed project.First, we will calculate the SUM of the Assigned Project and Completed Project, before that make sure you have Loaded the data using the get data option.In this example, we will divide and calculate how many hours have taken Per Member of a Team to complete the project.In the below table, you can see that there are different Teams, and each Team has a different Team members count and Total hours to complete the project.Here, we will use the below sample table data to calculate the hours taken per member to complete the assigned project.Let us see how we can divide the two columns using the Power BI Divide function. Here you can download the excel file used in this example. Now we will see a few examples down based on the Divide function in Power BI. The below represented is the syntax for the divide function,.Optionally, we can pass a value that represents an alternate result. If we are using the divide function then we have to pass the numerator and denominator expressions.In Power BI, to divide the two columns we use the Divide function, Either we can choose the divide function or the ( / – forward slash) divide operator.Power Bi divides one measure by another.Power Bi divides two columns with a filter.Power Bi divides two columns in a matrix.Power BI divides two columns from different tables.Power BI divides two columns by each row.Power BI divides two columns with a filter.Power BI divides two calculated columns.Power BI divides the sum of two columns.Power BI divides two columns of percentage.Power BI divides two columns to measure.Power Bi divides two columns in a table.