cancel
Showing results 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

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.

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

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

#### Power BI Monthly Update - August 2024

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

#### Fabric Community Update - August 2024

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

Top Solution Authors
Top Kudoed Authors