Filter Hirerachy

[Baskar]

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 ?

[v-sihou-msft]

@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.

Regards,

[MattAllington]

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

[KHorseman]

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.