Forum Discussion
Count Distinct where JobStatus = Max(JobStatus)
Hi, I have the following table A which stores the Job Stream and Job Status of some jobs by Country. TableA: Country Job Stream Jobs Job Start Time Status Hong Kong StreamA Job1 ...
Greg_Deckler
Community Champion
Community Championkkt - This looks like Lookup Min/Max - https://community.powerbi.com/t5/Quick-Measures-Gallery/Lookup-Min-Max/m-p/985814#M434
So:
Overall Status Measure =
VAR __Max = MAX('TableA'[Job Start Time])
RETURN
MAXX(FILTER('TableA',[Job Start Time] = __Max),[Status])