Forum Discussion
Return True when all values are equal to True, otherwise return false
Hi Team, I have been working on a report which shows the status of timesheet approvals via departments and employees. This is the current report look and feel Overall, I am using a cur...
Anonymous also I would just point out that the HASONEVALUE() method is probably not quite optimally precise, if what you truly care about is whether the values are all TRUE. In a scenario where all values are FALSE I think that measure would be returning TRUE as well.
Something like below might be more exact:
IF(SELECTEDVALUE('hf TimeSheet'[Authorised]) = TRUE(), TRUE(), FALSE())
I did attempt that Measure, and the results are below. All timesheets have been approved for this past date. Yet it still seems to throw a False.