Forum Discussion

Bobbo's avatar
Bobbo
Regular Visitor
6 years ago
Solved

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 ...
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    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.

parry2k's avatar
parry2k
Super User
6 years ago

Bobbo what is your expected output? And when you say filter, what you mean ?

Bobbo's avatar
Bobbo
Regular Visitor
6 years ago

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.

  • parry2k's avatar
    parry2k
    Super User
    6 years ago

    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!