Forum Discussion

PaulMac's avatar
PaulMac
Icon for Helper IV rankHelper 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
Icon for Microsoft Employee rankMicrosoft 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

PaulMac's avatar
PaulMac
Icon for Helper IV rankHelper IV
7 years ago

Hi v-jiascu-msft

 

I am afraid that was not the correct measure. Using your exampled yeilded a result of 0 across all rows.

 

If calls offered (value 21) is in column B and Files Uploaded (value 5,113) is in column D then I can do this simply in Excel with =B1/D1*1000. (21/5113)*1000=4.11

 

Why is this so hard to replicate as a dax measure?

 

Anyone else have any suggestions?

 

PaulMac