cancel
Showing results for
Did you mean:
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
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.

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!
Helper IV

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?

Community Support

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

Helper IV

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]

Community Support

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

Helper IV

@v-kelly-msft  sent you a private message

Community Support

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

Helper IV

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

Community Support

Hi @bryanc78 ,

Best Regards,
Kelly

Community Support

Hi @bryanc78 ,

Remember to remove the confidential information.

Best Regards,
Kelly

Announcements

#### Launching new user group features

Learn how to create your own user groups today!