DAX formula with calculate

[SaaM]

Hi,

I was wondering what is the impact in the performances of my report while using two formulas and which would be the best to calculate a precentage:

My visual have filter with elements from table_1 and table_2

Calculate(Calculate(sum(myfield), All(mytable_1)), All(mytable_2))) 

Vs.

Calculate(sum(myfield), Removefilters())) 

Which one i should go for ?

Thanks in advance

Kind regards

Saam

[lbendlin · Accepted solution]

If in doubt, use DAX Studio and study the query plans generated by the two versions.  Make sure to provide large-ish tables so you can see the impact of cartesian products better.