Forum Discussion
bi-passing filter selection
Hi , I have data as representated below. I have Page level filters on Year,Category and Subcatagory. I want to bi-pass "Category" and "Subcatgory" filter selection on Tagert sales. Any idea how th...
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]))