Forum Discussion

PaulMac's avatar
PaulMac
Helper IV
7 years ago

Having Issues With a Simple Calculation

Hello all   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 Num...
Need Help
v-jiascu-msft's avatar
v-jiascu-msft
Microsoft Employee
7 years ago

Hi Paul,

 

The final solution is based on your data model. But you can try it like below. CALCULATE isn't necessary in your scenario.

 

Calls per 1000 API Files Uploaded =
MIN ( 'All_Phones'[Offered] ) / MIN ( 'Files Uploaded'[API] )
    * 1000

 

Best Regards,
Dale