Forum Discussion

Rabi's avatar
Rabi
Resolver I
2 years ago
Solved

Measure Does Not work Properly.

Full Name Contract Hours Worked Hours Pay date ABC 76 7.6 15/01/2024 ABC 76 7.6 15/01/2024 ABC 76 14 15/01/2024 JOHN 42 6 28/01/2024 JOHN 42 25 28/01/2024 J...
"DAX help"
"Help"
"Need Help"
DAX help needed
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi Rabi ,

    You can create another measure as below and apply a visual-level filter to filter the data which [Difference] is less than 0. Please find the details in the attachment.

    Flag = IF( MINX(ALLSELECTED('SAMPLE'[Pay date]),[Difference]) < 0, 1)

    Best Regards

Mahesh0016's avatar
Mahesh0016
Super User
2 years ago

Hello Rabi,

Could you please share the expected output? This will help us better understand the problem.