Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

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

Hello brilliant community,   I am new to Power BI. Would really appreciate if someone can help me out with this simple division of a column by another column to calculate Overdue percentage column:...
Need Help
Anonymous's avatar
Anonymous
Not applicable
8 years ago

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 

Before: 

 

Org    Loc   Case counts  Overdue cases

WA     ABC      18              9

 

After:

 

Org    Loc   Case counts  Overdue cases   %Overdue

WA     ABC      9              0                          0.0%

WA     ABC      9              9                          100.0%

 

Please advise.

 

Anonymous's avatar
Anonymous
Not applicable
8 years ago

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    The data is sourced from a table in a spreadsheet. I figured out the error, I didn't pull the data from another related spreadsheet.

    Thanks