Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
Solved! Go to 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.
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.
User | Count |
---|---|
41 | |
27 | |
23 | |
19 | |
16 |
User | Count |
---|---|
55 | |
35 | |
21 | |
18 | |
15 |