Forum Discussion

alexstock01's avatar
alexstock01
Regular Visitor
2 years ago
Solved

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...
  • Ritaf1983's avatar
    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