Optimize DAX query in roles management

Anonymous — Mon, 11 Oct 2021 08:09:51 GMT

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 :

Use SEARCH() with the last parameter
The SEARCH() DAX function accepts the last parameter as the value that the query must return if the search string is not found. You should always use the SEARCH() function instead of using Error functions along with SEARCH().
Use variables instead of repeating measures inside the IF branch
I don't know if two IF statement is a good practice.

( 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 !

Re: Optimize DAX query in roles management

Anonymous — Mon, 11 Oct 2021 09:15:00 GMT

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() )

topic Re: Optimize DAX query in roles management in DAX Commands and Tips

Optimize DAX query in roles management

Re: Optimize DAX query in roles management