Best way to combine two measured columns

[MP-iCONN]

I have two columns that have a filtered value and I wanted to see the best way to combine them into another column using DAX.

Number = zBookings[Booked Amt SUM]/(SUM(Invoice[IVM_InvoiceAmt]))

THAT NUMBER IS .88 for example

Denom = SUM(Invoice[IVM_InvoiceAmt])/SUM(Invoice[IVM_InvoiceAmt])

THAT NUMBER IS 1.00 for example

I want to combine these values into another column called Ratio and have it display as 0.88:1.0 with the colon as the seperator.

I tried everything I could to figure this out but wanted to see if anyone had a solution.

Thank your for any help with this.

Chad

[Greg_Deckler · Accepted solution]

@MP-iCONN Maybe:

Column = FORMAT([Number],"0.00") & ":" & FORMAT([Denom],"0.0")

[MP-iCONN]

Thank you very much, this worked perfect!