bi-passing filter selection

kanth123 , One way is to stop interactions. - https://docs.microsoft.com/en-us/power-bi/create-reports/service-reports-visual-interactions

The second is to have a category table with category and subcategory and use all on that

calculate(countrows(Table) , all(Category [Category ]))

or use on the same table

calculate(countrows(Table) , all(Table[Category],Table[Subcatagory]))

@amitchandak Thanks for your response, I can't use stop intraction functionality. In the report I am showing Product, Sum (Amount), Sum (TargetSales). so when the user selects Year, they must apply a filter on both "Amount" and "Target sales". Category and subcategory selections should not affect Sum (Target Sales)

Thank you..

Hi kanth123 ,

Not very clear...Do you want to ingore the page level filter of Year?

You could use ALLEXCEPT() function like this:

Measure =
CALCULATE (
    SUM ( 'Table'[TargetSales] ),
    ALLEXCEPT ( 'Table', 'Table'[Category], 'Table'[Subcategory] )
)

Here is the pbix file.

Best Regards,
Eyelyn Qin

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Hi kanth123 ,

Sorry to disturb you...

But did I answer your question ? Please mark my reply as solution. Thank you very much.

Best Regards,
Eyelyn Qin