Forum Discussion
Problem with dax query time
Hey guys, I am having processing problems in a dax query below: FLEX_METRICA_CALCULO_MERCADOMARCA_AREA_VISITADA = var vfilter = FILTER( VEEVA_D_FORCA_DE_VENDAS ,not ISBLANK(VEEVA...
Thanks for your great suggestions.
Option 1 worked and returned the same value, I even tried using crossjoin and it also worked, but it seems that the performance is still bad... in the model the DEMANDA_SETOR_BRICK table has 3 million rows and I believe that it is directly affecting performance due to the relations...
CALCULATE(
CALCULATE(
[FLEX_METRICA_CALCULO_MERCADOMARCA_AREA_VISITADA]
,USERELATIONSHIP(D_MARCA[MERCADO],IM_D_MERCADO_FRANQUIA[MERCADO])
)
,CROSSJOIN(VEEVA_D_FORCA_DE_VENDAS, D_LINHA)
)
Understood - thanks for the update.
I'm not sure I can help much more here - this probably requires more detailed inspection of the model and testing to resolve.