Forum Discussion

Sean-OReilly's avatar
Sean-OReilly
Icon for Helper IV rankHelper IV
6 years ago
Solved

Need Help with a DAX Measure

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"

 

 

 

Need Help DAX measure
  • Anonymous's avatar
    Anonymous
    6 years ago

    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!

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    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!