Forum Discussion
Solved
Help with DAX Allexcept filtering
Hi, I have a Table called Tracking, as shown below: Category,Item Id,Work Date A,1,1/1/2020 B,1,2/1/2020 C,1,3/1/2020 D,1,4/1/2020 A,2,7/1/2020 B,2,8/1/2020 C,2,9/1/2020 D,2,10/1/2020 Usin...
Your DAX expression was not written properly. ")" is not place right. It should be after the Item ID column.
You can review
lbendlin
Super User
Super UserChange your measure to
maxWorkDate = MAXX(Tracking,Tracking[Work Date])
and use a visuals filter to exclude D
That didn't work. It brought maximum work date from the ENTIRE table i.e. 10/1/2020 whereas after excluding Category D via visual filter, for Item 1, the maximum work date should be 3/1/2020 and for Item 2, the maximum work date should be 9/1/2020.
