Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

DAX Optimization help request

Hi Everyone,    I have a query that take timeout error, can you please help me to optimise the dax query?   Query is below that;   DEFINE VAR CA = SUMMARIZE ( 'FACT_SALES', 'FACT_SALES'[CLI...
Dangar332's avatar
Dangar332
Resident Rockstar
2 years ago

hi, Anonymous 

 

DEFINE
VAR CA =
addcolumn(
all('FACT_SALES'[CLIENT_ID]),
"client_xx",
IF (
  CALCULATE (
     SUM ( 'FACT_SALES'[MONTANTNET] ),
     USERELATIONSHIP ( 'DIM Representant'[REPRESENTANT_ID], 'FACT_SALES'[REPRESENTANT_ID] )
  ) > 0.00001,
1,
0
))
RETURN
SUMX ( CA, [client_xx] )