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

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
Anonymous
Not applicable

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

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

Join us as experts from around the world come together to shape the future of data and AI!
At the Microsoft Analytics Community Conference, global leaders and influential voices are stepping up to share their knowledge and help you master the latest in Microsoft Fabric, Copilot, and Purview.
️ November 12th-14th, 2024
 Online Event
Register Here
Anonymous
Not applicable

@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 @Anonymous ,

 

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!

Anonymous
Not applicable

@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 @Anonymous ,

 

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!

Anonymous
Not applicable

@v-kelly-msft  sent you a private message

Hi @Anonymous ,

 

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!

Anonymous
Not applicable

@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 @Anonymous ,

 

Have you uploaded your .pbix file?

 

Best Regards,
Kelly

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

Hi @Anonymous ,

 

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
October NL Carousel

Fabric Community Update - October 2024

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