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
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
@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.
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:
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 @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!
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!
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!
User | Count |
---|---|
123 | |
96 | |
89 | |
73 | |
63 |
User | Count |
---|---|
138 | |
115 | |
111 | |
98 | |
95 |