Skip to main content
cancel
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.

Reply
cpereyra
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)

 

PBI.PNG

 

Thanks in advance.

 

2 REPLIES 2
amitchandak
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 -

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

JarroVGIT
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:

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

 





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

Proud to be a Super User!




Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

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

MayPowerBICarousel

Power BI Monthly Update - May 2024

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