Hi!
I'm new to DAX and I've been struggling to get my IF statement to calculate correctly once a slicer selection has been made.
I have two main sources of data and both are linked by the individual's email address.:
- List of dates/times associated to individuals log ins across the period of a month
- List of no. days they should have logged in
The IF statement I am trying is:
IF('Employee record'[No. days required]<[Count No. log in],"Yes","No")
This works fine until a date range is selected on the log in date slicer. It continues to calculate based on the original value, not the new filtered value.
The 'Employee record'[No. days required] is static data but the [Count No. log in] is a calculated column which is:
IF(ISFILTERED('Single count log in'[Log in date]),COUNTROWS('Single count log in'),"Unfiltered") - I have also tried this without the isfiltered element and just counting the rows of that column and the same issue occurs.
How do I get the IF statement to re-adjut based on the slicer selection?
Thank you!
