Forum Discussion
Resident RockstarFilter 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
- MattAllington
Community Champion
Filters are always a logical AND, so order is not important.
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.
v-sihou-msftMicrosoft Employee
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.
Regards,
