multiple filters in measure

[pbilearner71]

Hi 

I am new to power bi and trying to understand the filter function. I have used multiple filters with calculate function and wondering if the order of those filters matter ?

the measure is:

Supplyvalues = calculate(sum('Supplies'[final Amount], filter('Supplies'[category]="engineering"), filter('Sales','Sales'[Value]="High"))

I am wondering if the results will change if I write the 'Value' filter first?

Thanks!!

[AlB · Accepted solution]

Hi @pbilearner71,

CALCULATED performs and AND of all the filters you provide and applies that to its first parameter. The order in which you enter the filters is thus irrelevant.

[pbilearner71]

Thanks much!!