- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

@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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

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?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

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:
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!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

My goal is this:
Final Measure = measure1 + measure2 + calculated column
My measure doesn't see the calculated column - in Red below
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

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!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

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!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Hi @Anonymous ,
Have you uploaded your .pbix file?
Best Regards,
Kelly
Did I answer your question? Mark my post as a solution!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

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
Subject | Author | Posted | |
---|---|---|---|
07-30-2024 07:42 AM | |||
08-21-2024 06:40 AM | |||
11-01-2023 09:01 AM | |||
07-23-2024 11:36 AM | |||
01-05-2024 01:06 PM |
User | Count |
---|---|
137 | |
107 | |
85 | |
59 | |
46 |