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
daxer-almighty
Solution Sage
Solution Sage[Max Work Date] =
calculate(
max( 'tracking'[work date] ),
distinct ( 'tracking'[item id] ),
'tracking'[category] <> "D",
all ( 'tracking' )
)