Forum Discussion
Help with Filters Please
I have a fairly simple filtering request that I need assistance with. I need a column to filter all columns in my table. My first column is the date a customer was last edited. I need this column to be set to the most recent date so that it filters all other columns. Column B is the customer name, Column C their sales, Column D their assigned sales person and so on. If I can make Column A represent that most recent date it should in turn filter all the other columns? Thank you in advance.
Hi Bobbo ,
Create a measure like below and add it to visual filter.
Measure = var most_recent = CALCULATE(MAX('Table'[Policy Date]),ALLEXCEPT('Table','Table'[Client])) return IF(SELECTEDVALUE('Table'[Policy Date])=most_recent,1,BLANK())Best Regards,
Jay
Community Support Team _ Jay Wang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
6 Replies
Bobbo not fully sure how your data looks like, share sample data.
Read this post to get your answer quickly.
https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490Policy Date Client Sales Sales Rep Regions 5/22/2019 ABC Company $85,000 Jim West 4/15/2019 ABC Company $50,000 Jim West 4/1/2019 ABC Company $10,000 Jim West 3/6/2019 XYZ Company $15,000 Jeff South 4/2/2019 XYZ Company $16,000 Jeff South 5/6/2019 XYZ Company $90,000 Jeff South
