Forum Discussion
Divide one column by another in a matrix
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!
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
3 Replies
- Ritaf1983
Super User
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
- Thank you so much! That was a great explanation and turned me in the right direction.
- Ritaf1983
Happy to help 🙂
