I am trying to replicate an excel formula in Power BI but I can't seem to do it.
I am trying to calculate the Total Calls per 1000 files uploaded.
In Excel column B contains Number of Calls Offered
Column C contains Number of Files Uploaded
My Excel formula reads as:
This get me the result I need in excel
I have tried to write this out in Power BI as:
Calls per 1000 API Files Uploaded =
But instead of a result I get the error message below
"A single value for column 'Offered' in table 'All_Phones' cannot be determined. This can happen when a measure formula refers to a column that contains many values without specifying an aggregation such as min, max, count, or sum to get a single result."
Please let me know where I am going wrong so I can stop feeling like an invalid sod!