need help on dax

[Krushnab85]

I have a table with sales and earnings columns, and i put those in the matrix where sales are in rows and the sum of earnings is in the values section. However, when I drag a "Earning point" measure into the values section of the matrix, I don't get the desired result. I have a slicer outside of the disconnected table of which is sales data, I need a solution such that if I select 297  in the slicer (which is a sales value from the disconnected table), it should display the maximum value of earnings between 297 and 300 in the matrix, specifically in front of 297 and 300 only. Similarly, if I select 350, it should show the maximum earnings value between 300 and 350 in front of 300 and 350 only (300 is fixed point). rest should be the blank

provide me the dax so i can put in the measure

[Idrissshatila]

HEllo @Krushnab85 ,

Please share sample data in a usable format (not screenshots) that fully addresses your issue or question.

Avoid including sensitive info or unrelated content. Need help uploading data? Visit https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...

Show what you expect based on the provided data.

For faster answers, see https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...

[Krushnab85]

please find the link for your reference - 
ic calculator.pbix

[Krushnab85]

Any Update @Idrissshatila ?