Divide a column value by another column in Matrix or table layout

Question

Hello brilliant community,&nbsp;I am new to Power BI. Would really appreciate if someone can help me out with this simple division of a&nbsp;column by another column to calculate Overdue percentage column:&nbsp;My data looks like this:&nbsp;Case counts&nbsp; &nbsp; Overdue cases&nbsp; &nbsp;%Overdue&nbsp; 50&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 15&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;30.00%&nbsp; 18&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 15&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;83.33%&nbsp;I have tried this&nbsp;Overdue percent = DIVIDE ('Table'[Overduecases],'Table'[CaseCount], 0)but it results in numerator..

greg_deckler · Answer

If you are doing that as a measure, then I believe that should be:&nbsp;DIVIDE(SUM('Table'[Overduecases]),SUM('Table'[CaseCount]), 0)Then set it to a format of % in the Modeling tab.

anonymous · Answer

Thanks for your reply smoupre, but I need not get the sum of the columns.

For exaple in sample data in my post %overdue for the first row is calucalted by diividing 15 by 50 & multiplying with100

anonymous · Answer

You can include a column(%Overdue) and use the formula that you had used earlier but ensure to set the format&nbsp;for&nbsp;%Overdue as Percentage and set the Default Summarization to Don't Summarize

anonymous · Answer

Thanks for your help Banurekham. It works, but it stems out another issue. My data is filtered by organization and location, as soon as I apply divide function to %Overdue column the rows from single organization and location split into two. Something like this&nbsp;Before:&nbsp;&nbsp;Org&nbsp; &nbsp; Loc&nbsp; &nbsp;Case counts&nbsp; Overdue casesWA&nbsp; &nbsp; &nbsp;ABC&nbsp; &nbsp; &nbsp; 18&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 9&nbsp;After:&nbsp;Org&nbsp; &nbsp; Loc&nbsp; &nbsp;Case counts&nbsp; Overdue cases&nbsp; &nbsp;%OverdueWA&nbsp; &nbsp; &nbsp;ABC&nbsp; &nbsp; &nbsp; 9&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;0&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 0.0%WA&nbsp; &nbsp; &nbsp;ABC&nbsp; &nbsp; &nbsp; 9&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 9&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 100.0%&nbsp;Please advise.&nbsp;

anonymous · Answer

Could you share the snapshot of the model or your sample data

Forum Discussion

Divide a column value by another column in Matrix or table layout

6 Replies

Related content

Divide one column by another

column should be divided in to two columns based on another column

Divide columns

Sort by another column

Divide the Sum of Two Columns by Sum of another Two columns