Need help with possible measure and filter.

[Anonymous]

I'm working on building out some views for a ticketing system that doesn't have the greatest interface.  A table I'm working on is simple, here's an example if Mark is looking at all tickets he's responsible for (and luckily he only has one to do in this example):

Ticket #	Submitter	Summary	Owner	Status	Last Update
1234	Tom	Excel won't load.	Mark	Under Review	3/12/2020 14:00:00

So this works fine.  My main goal is to provide a list of tickets and when it was last updated by someone.  My current visualization does that, but now I'm wanting to add a 7th column onto the end to show who it was that made the last update, however when I do add that column, it creates a new row for each person who has touched the ticket along with their last update.  So if a ticket has had four people touch it (let's say the submitter plus 3 technicians), then it will spit out 4 rows for that one ticket # and show the last time each person put a note.  I only want to show the last person who updated it and that's it.

I fully understand why Power BI is doing this but I don't quite know how to fix it.  I believe it involves setting up a measure in some way to filter out anything but the newest value but I'm stuck on how to write it so that it's looking at each ticket on an individual basis.  If anyone can provide some help, it'd be appreciated.

[v-shex-msft]

HI @Anonymous,

Current power bi does not support to create dynamic calculate column/table based filters, I'd like to suggest you use the measure to instead. (measure results are based on its row contents, so it can interact with visuals and filters. measure and visuals source is virtual and generated/copy from data model tables, its filters, interactions not able to effect with parent level)
Regards,

Xiaoxin Sheng

[Greg_Deckler · Accepted solution]

So perhaps a measure like:

Last Updated By Measure =
  VAR __LastUpdated = MAX('Table'[Last Updated])
RETURN
  MAXX(FILTER('Table',[Last Update] = __LastUpdated),[Column])

Difficult to be specific. Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490