Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi, I created a role which is too slow because of its DAX query :
Can you help me to optimize it ?
I already read some best practices like :
( IF( ISERROR( SEARCH("France - Monaco" , DIMENSION_individual[regions_all_boutique_purchase_individual]) ), FALSE(), TRUE() ) ) && ( IF( ISERROR( SEARCH("Fashion" , DIMENSION_individual[distribution_all_networks_boutique_individual]) ), FALSE(), TRUE() ) )
Thanks in advance !
Hi,
Here is my optimization, can we do better ?
IF( OR(
SEARCH("France - Monaco" , DIMENSION_individual[regions_all_boutique_purchase_individual],,0)=0,
SEARCH("Fashion" , DIMENSION_individual[distribution_all_networks_boutique_individual],,0)=0
) , FALSE(), TRUE() )
User | Count |
---|---|
42 | |
28 | |
24 | |
20 | |
16 |
User | Count |
---|---|
54 | |
35 | |
18 | |
18 | |
15 |