Forum Discussion
alexstock01
2 years agoRegular Visitor
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 al...
- 2 years ago
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
Ritaf1983
Super User
2 years agoHappy to help 🙂