Filter Power BI data based on Selected filter range value

HI Ashish, 

Yes, it will.

And how I would have below implementation on top of this data.

My ultimate requirement is when user selects Bucket <25%, then table will have only those records where % of amount with total amount (Amount/Total Amount) is less than <25%, and once will have this dataset, then need to display summarized report via Matrix report (i.e. Matrix report will built on only data which is available after applying Bucket<25% filter), layout of report looks somewhat similar to the below (numbers shown are dummy records).

Can understand, as logic you suggested is based on row to row basis so it will not work on summarized data, can you please help me how to do it in Matrix report.

Please suggest!!

Thanks

Amit