I have created a conditional dax measure to tag each account with "Current" and "Past Due".
Not sure, if you could have created this a New Column, instead of measure.
Second, you can put that into a Matrix and it should allow filter when you click on the value.
Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @ Thanks.
Join us in the third Triple A event!
It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.
Make sure you didn't miss any of the things that happened in the community in January!