Forum Discussion
Help with DAX
In my Cube table I have a table showing employee and the number of hours they have submitted late in their timesheets by week.
For example, if I filter for all the weeks in Feb 2023 I can see that employee 123 was late for some weeks and on time for others.
In my Power BI report I want to be able to tag them as 'Late' if they were late for at least one of the weeks selected.
At the moment as my DAX is at row level, they are being tagged as both 'Late' and 'Not Late' in the report. I only want to see them tagged as 'Late' as, for the Feb 2023 period selected, they 'failed'...they are 'Late' for at least one week.
I only want to see employees with zero late hours for the period selected tagged as 'Not Late' in my report.
The key point is that I want to see employees listed only once in the report, either as 'Late' or 'Not Late', for the period of time selected.
In my Cube Table I've tried using filters, eg SELECTED VALUE and ALLEXCEPT (and others) and have not been able to solve this, what's the correct DAX to use ?