Divide one column by another in a matrix

[alexstock01]

Hey everyone, I am pretty new to Power BI and could use some help here. I will have screenshots included to explain. I have a matrix with 2 columns titled "0" and "1". Together they are the sum of all payments made but the "0" is payments coming in and the "1" is payments coming out. I am trying to add a third column that tells me the ROI by having the "1" column divided by the "0" column. This data is coming from the "EAGLEADV_Payment" data report. Just disregard everything else on the dashboard except the matrix. Thanks! 

[Ritaf1983]

Happy to help 🙂

[Ritaf1983 · Accepted solution]

Hi @alexstock01 
You can create 3 needed measures.
For example, my table looks like :

So the measures will be:
1.Credit = CALCULATE(sum('Table'[Value]),'Table'[type]="credit")

2. 

Debit = CALCULATE(sum('Table'[Value]),'Table'[type]="debit")

3. 

ROI = DIVIDE([Debit],[Credit])

pbix is attached you can follow my steps

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

[alexstock01]

Thank you so much! That was a great explanation and turned me in the right direction.