Calculate Cost per unit

[cpereyra]

Hi everyone,

I need to calculate the cost per unit based on different salaries. This table is counting the units by a field count in values. I'm trying to get the same table but divinding the salary for the number of units in the month. This was my attempt but it is not working out. 

Processor Count = if(Merge1[LP_NAME]="Garcia",1,0)

Processor file per month = CALCULATE(sum(Merge1[Processor Count]),FILTER(Merge1,Merge1[PEC_Work_Load.Log_MS_Date_Initial_QC (bins)]= EARLIER(Merge1[PEC_Work_Load.Log_MS_Date_Initial_QC (bins)])))

Processor Cost Per Loan = If(Merge1[LP_NAME]="Andy Garcia",3333/Merge1[Processor file per month],0)

Thanks in advance.

[amitchandak]

Can you share the raw data with expected results. If possible please share a sample pbix file after removing sensitive information.Thanks.

My Recent Blog -

https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-tr...

[JarroVGIT]

I read your post twice but still have absolutely no idea what it is you are trying to achieve or what the problem is. Please explain in more detail, perhaps this guideline will help:

https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/bc-p/88509...

Kind regards

Djerro123

-------------------------------

If this answered your question, please mark it as the Solution. This also helps others to find what they are looking for.

Keep those thumbs up coming! 🙂