Need Help with a DAX Measure

[Sean-OReilly]

Hi

I need to calculate a measure to return "Job Description" based on a filter of Sub-Job = 0 

e.g the answer i want below is "TII Boardroom C18041"

[harshnathani · Accepted solution]

HI @Sean-OReilly ,

Create a Measure

Measure = CALCULATE(MAX('Table'[Job_Description]),'Table'[Sub_JOB_Number] = 0))

Regards,
Harsh Nathani

Appreciate with a Kudos!! (Click the Thumbs Up Button)
Did I answer your question? Mark my post as a solution!

[Sean-OReilly]

thanks Harsh