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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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.

@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
July 2024 Power BI Update

Power BI Monthly Update - July 2024

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

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors