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
Mahesh0016 Thanks for your contribution on this thread.
Hi Rabi ,
I created a sample pbix file(see the attachment) base on your provided sample data and measures, it can return the expected result. How did you set your matrix visual? Is something missing here?
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 !!