Forum Discussion
Return True when all values are equal to True, otherwise return false
Anonymous your current approach seems sound, so there must be something I'm missing.
As a troubleshooting step, could you create a table visual filtered to a with a single department and day, showing the values of [Authorized]?
That might help us determine where the HASONEVALUE() approach is failing.
Hi Anonymous ,
I've created quick filter some data. Selected 1 Department and 1 Date. Output is this. Where 1 employee has had their timesheet approved, the other havn't yet.
Anonymous ok, but based on this data you're showing here the expected result for this department and day context in your matrix would be FALSE (because [Authorised] contains more than a single distinct value). Do you have a specific example where the measure should be returning TRUE but isn't?
Hey mate, using your Measure, it looks to be working when department has a single Employee.
This is from lastweeks, so every field should be true due approval has to happen before payroll.
I have a feeling its something to do with the ROW contexting BI does, but this is now into realm beyond my technical knowledge of BI 🙂