column to add measures together then subtract by a number

[bryanc78]

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

[amitchandak]

@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.

[bryanc78]

@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?

[v-kelly-msft]

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:

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!

[bryanc78]

@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]

[v-kelly-msft]

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!

[bryanc78]

@v-kelly-msft  sent you a private message

[v-kelly-msft]

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!

[bryanc78]

@v-kelly-msft 

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

[v-kelly-msft]

Hi @bryanc78 ,

Have you uploaded your .pbix file?

Best Regards,
Kelly

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

[v-kelly-msft]

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!