Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
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
@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.
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 @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!
My goal is this:
Final Measure = measure1 + measure2 + calculated column
My measure doesn't see the calculated column - in Red below
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!
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!
Hi @bryanc78 ,
Have you uploaded your .pbix file?
Best Regards,
Kelly
Did I answer your question? Mark my post as a solution!
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!
Check out the September 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
114 | |
106 | |
94 | |
38 | |
34 |
User | Count |
---|---|
151 | |
122 | |
76 | |
74 | |
50 |