I have two table Table1 & Table2, relationship between this tables is Many(Table1) to One(Table2) below is the structure & data of the tables

I need to create 2 buttons for my report which filter ALL of the visuals on my page based on multiple conditions. I have tried using bookmarks with buttons but my issue is that you can only use bookmarks with slicers and my conditions are slightly complex.

I have a lot of duplicate lines in my sales value, these lines are the result of a large query breakdown with sublevels. But now I need to calculate the sum of sales by ordernumber and itemnumber, so my output for pepsi would be 18 and for coca cola would be 24.

I need to calculate a prorate value with dax
I have 2 tables:

I am struglling to getting top 25 unique customers when filtering the table using Alert_Id. Basically, I have these columns in table which you can find below. The goal is to show top 25 unique customers based on highest value. The Item can be repeated but name has to be unique. I have tried so many different things but nothing seems to be working as expected because of Multiple customers have used multiple items and hence I am getting duplicate rows. The table has to be dymic because whenever user filters the table using Alert_id it should return those top unique customers that associated with Alert_id(Alert_id is a single selection). So whenever user select their Alert_id that table should display their data. I have tried below measure,
First I created calculated column to break the tie for price because many Item shares the same price: