Find max records in straight table then count matching

[Delestia]

I have a tabular table in the format below loaded into my app

Package Series	Record ID	Package Phase Tracking ID	Package Phase ID
2019-000028	909	2547	1391
2019-000028	910	2548	1419
2019-000029	911	2556	1391
2019-000029	911	2558	1419

I am trying to produce a test straight table on a sheet of only the Max "Package Phase Tracking ID" in each "Package Series"

Package Series	Record ID	Package Phase Tracking ID	Package Phase ID
2019-000028	910	2548	1419
2019-000029	911	2558	1419

I'm not having much success using a measure of Max(total <[Package Series]> Aggr([Package Phase Tracking ID], [Package Series], [Record ID]))

The purpose of this is to then produce a bar chart that counts the resultant quantity of Package Phase IDs as a dimension

[lironbaram · Accepted solution]

hi 

you can use this calculated dimension , 

=if([Package Phase Tracking ID]= aggr(nodistinct max([Package Phase Tracking ID]),[Package Series]),[Package Phase ID])

then use count(packge series) as measure for the bar chart  

[Delestia]

Thank you so much for this!  My only tweak was to add Distinct to the count of [Package Series] such that it didn't duplicate for my data set.