Skip to main content
Showing results for 
Search instead for 
Did you mean: 

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric 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

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.


Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.