Forum Discussion
Measure Does Not work Properly.
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 can you please have a look at this thread https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Same-DAX-measure-gives-different-Result-PBIX-attached/m-p/3931900#M152980 i have attached a sample PBIX with the result i want to achieve.
Thank you !!
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
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 !!