I have a 3 measures related to absence:
1 Calculate number of working days in month - (2.5 days leave allowed)
File attached to help
How about wrapping the result inside a MAX
MAX(answer that may be negative,0)
if it is negative, you get zero instead
Take a look at the September 2023 Power BI update to learn more.
Join Microsoft Reactor and learn from developers.