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
Sept PBI Carousel

Power BI Monthly Update - September 2024

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

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

Sept NL Carousel

Fabric Community Update - September 2024

Find out what's new and trending in the Fabric Community.