Performance improvements in dax measure

[Anonymous]

Bllow measure is taking more time :

CALCULATE (
SUMX (
SUMMARIZE (
ALLSELECTED(table),
table[test_shr_grp_cd],
"total_Client",

CALCULATE (
MAX ( table[cr_utilisation_amt_cnt] )
,table[First_char_cred_shared_grp_Cd] = "G"
)

),
[total_Client]
),
table[test_grp_code(Y/N)] = 1
)

[v-shex-msft]

Hi @Anonymous,

I'd like to suggest you take a look at the following blog that mentioned optimizing nested iterator performance:

Optimizing nested iterators in DAX - SQLBI

Regards,

Xiaoxin Sheng

[amitchandak]

@Anonymous , Try like

sumx(summarize(filter(allselTable, table[First_char_cred_shared_grp_Cd] = "G" && table[test_grp_code(Y/N)] = 1), table[test_shr_grp_cd],
"total_Client",MAX ( table[cr_utilisation_amt_cnt] ) ),[_1])