cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
bryanc78
Helper IV
Helper IV

column to add measures together then subtract by a number

I can get the 3 measures to add up correctly but then when I try to subtract that number by another number, the math doesn't wortk

 

Attendance Score = (WFT[Call Off]*1.5)+(WFT[Leave Early]*0.5)+(WFT[Late/LB]*0.5)
This equals 16 for one of my employees as it should
 
Attendance Score = 40-((WFT[Call Off]*1.5)+(WFT[Leave Early]*0.5)+(WFT[Late/LB]*0.5))
This on the other hands does not subtract 16 from 40.  Instead of 24, I get 624
 
Any ideas?  This works in excel so I'm sure I'm using the wrong syntax
10 REPLIES 10
amitchandak
Super User
Super User

@bryanc78 , I am sure these are measure and you created a measure like this

40-(([Call Off]*1.5)+([Leave Early]*0.5)+([Late/LB]*0.5))

 

hope the Attendance Score is not a new column

 

Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

Did I answer your question? Mark my post as a solution! Appreciate your Kudos!! !!
Dashboard of My Blogs !! Connect on Linkedin

Learn Power BI Beginners !! Advance Power BI Concepts !! Power BI For Tableau User !! Learn Power BI in Hindi !!
Proud to be a Super User!

@amitchandak 

 

That worked!

 

Last question for now.  To get an overall score, I need to add up several measures from different tables.  One problem I'm having is one of the items I need to include is a calculated column (it's a logical statement column) and my measure doesn't see it.  Is there a way that a Measure can see a calculated column?

Hi @bryanc78 ,

 

It's really hard to reproduce your senario just based on your description,as you see below:

 

Measure 3 = 20-'Table'[Measure 2]-'Table (2)'[Measure]

 

Measure 2 is  a measure including a calculated column;

But all work fine:

v-kelly-msft_0-1611040670293.png

So if possible,could you pls upload your .pbix file to onedrive business and share the link with us?Remember to remove the confidential information.

 

 

 

Best Regards,
Kelly

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

@v-kelly-msft 

My goal is this:

 

Final Measure =  measure1 + measure2 + calculated column

 

My measure doesn't see the calculated column - in Red below

Final Rank = Phone[Phone Rank] + Attendance[Attendance Ranking Score] + ('Employee DB')[Tenure Score]

 

Hi @bryanc78 ,

 

The link of your .pbix file is not public,and i cant access it,could you pls modify the link with a public one.

Thank you.

 

Best Regards,
Kelly

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

@v-kelly-msft  sent you a private message

Hi @bryanc78 ,

 

Sorry,but we can only support forum,we cant provide any private contact information.😐

If your data is sensitive,could you pls make a sample .pbix file with sample data inside which can help solve your issue?

 

Best Regards,
Kelly

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

@v-kelly-msft 

 

I have a sample file but I don't know how to give it to you.  Can I upload it here?

Hi @bryanc78 ,

 

Have you uploaded your .pbix file?

 

Best Regards,
Kelly

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

Hi @bryanc78 ,

 

Sorry for the late reply,you could upload your .pbix file to onedrive business and share the link with us.

Remember to remove the confidential information.

 

Best Regards,
Kelly

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

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

November Power BI Update 768x460.png

Check it Out!

Click here to read more about the November 2021 Updates!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.