Urgent!! Dax Help Required For calculation

Hi Anonymous 

The result if you have provided is wrong, i think you haven't check the correctly what is my requirement. 

----Based on your description and your sample, you are trying to determine whether site is continuously declining or not by Sales_Decrease-----

-->My Requirement is to get only those site which is continously sales went down on those month selection dynamically.

Example :- Let say i have selected from Apr 23 to Aug 23 in my slicer so total month will be 5(Count of month)
Then i need to now find out only those site which sales was continous down in these 5 month. other site we don't want in table.

LIke this if i select 6 month or 8 month then in table chart only those site need to show which was continous down 6 times or 8 times.

Your result is not correct at all.

If you check my pbix file then there if you will select 4 month, 6 month or 7 month you will get the site_count 4, 6, 7 mean those sites are continous down by these times but rest data is coming which we don't want.