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

Anonymous's avatar
Anonymous
Not applicable
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

Rabi's avatar
Rabi
Resolver I
2 years ago

Hi Anonymous , I appreciate your help, But I need to have only negative values in the matrix as I have thousands of employee data to show.

 

Thanks !!