Power BI new messure

[msarfaraz]

Hi
I just would like to ask about new messure
In my case TableA has two fields Room Revenue and Room nights i need to calculate Averge daily rates and formula should be room revenue / room nights. How i should write the formula, which will read in report.

 

[Matt Allington]

There are a few ways. I assume you mean 2 columns.

Sum(tableA[room revenue]) /sum(tableA[room nights])