cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Super User
Super User

Filter Hirerachy

Hi Champions,

 

1. I have a doubt, i want to know which filter apply first.

 

Eg. i have calculate filed with filter, and i have visual filter too,

 

2. I have multiple filter in visual level , may i know

what is the hirerachy it will aplly ?

 

In orderwise ?

 

 

 

3 REPLIES 3
Super User
Super User

Re: Filter Hirerachy

Filters are always a logical AND, so order is not important. 



* Matt is a Microsoft MVP (Power BI) and author of the Power BI Book Supercharge Power BI.
Super User
Super User

Re: Filter Hirerachy

That said, making a selection on an actual slicer visual will undo any selection you've previously made on another slice-ish visual like a bar chart. So if you want to select both an item on a slicer and an item on a bar chart, select the slicer first unless you enjoy clicking on the same thing twice.

Moderator v-sihou-msft
Moderator

Re: Filter Hirerachy

@Baskar

 

Both filters in CALCULATE() and visual filters are restricting the context of evaluation.  All filters will be applied with AND logic into your calculation. There's no order when evalutating.

 

Capture65.PNGCapture66.PNG

 

Regards,