Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

Helper I
Helper I

Calculate Cost per unit

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.


Super User
Super User

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 -

Resident Rockstar
Resident Rockstar

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:


Kind regards



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! 🙂


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Helpful resources

PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors