Forum Discussion
Help with Filters Please
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.
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/38490
| Policy 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 |
Thank you for following up. I would like to eliminate that transaction that did not take place on the most recent date. I do not need to total the columns, just be left with one row for each Client that indicates the most recent Sale.
Bobbo see attached, look at a table called DD (ignore other tables in the file) and the measure, you can take it from there and change as per your requirements.
I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!
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.