Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Am trying to filter one table with data from another related table but the syntax is beating me... new utilisation = FORMAT(DIVIDE(SUM('time_entries'[hours]), FILTER(ALLSELECTED(tasks),'tasks'[task name] = "On Leave")), [Max Possible Hours]), "Percent")
I need to take the sum of time_entries'[hours], filter it by a task called 'On leave' (from another table) and then divide it by another measure called Max Possible Hours. The filter thing is not working out for me. Can anyone help?
Solved! Go to Solution.
@sputnik76 do you mean :
new utilisation = DIVIDE(CALCULATE(SUM('time_entries'[hours]), 'tasks'[task name] <> "On Leave"), [Max Possible Hours], 0)
Please try.
Aiolos Zhao
Proud to be a Super User!
Hi @sputnik76 ,
Please try below code:
new utilisation = DIVIDE(CALCULATE(SUM('time_entries'[hours]), 'tasks'[task name] = "On Leave"), [Max Possible Hours], 0)
Thanks.
Aiolos Zhao
Proud to be a Super User!
Nearly works. If I want to make filter for everything EXCEPT 'On leave, how would I achieve that?
@sputnik76 do you mean :
new utilisation = DIVIDE(CALCULATE(SUM('time_entries'[hours]), 'tasks'[task name] <> "On Leave"), [Max Possible Hours], 0)
Please try.
Aiolos Zhao
Proud to be a Super User!
Great thank you!
I'm glad to help you, if my answer is correct, could you please mark it as "accepted solution"?
Thanks.
Aiolos Zhao
Proud to be a Super User!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
100 | |
81 | |
70 | |
62 |
User | Count |
---|---|
148 | |
116 | |
104 | |
90 | |
65 |