Forum Discussion
Slow DAX measure
Hi Experts I have the following measure which works out the p value and tau value for each row in my fact table which has 250000 row in it.. Both the p value and tau value are measures themselve...
your code could look something like this
Downward = CALCULATE ( COUNTA ( 'PMS_COMPLAINT'[MATERIAL_ID] ), FILTER ( ALL ( 'PMS_FINANCIAL_PDS' ), MAX ( [p-value] ) <= 0.05 && [TAU 1] < 0 ) ) + 0But, are '_Measures'[p-value] a variable in this measure? It is not part of the code you posted.
sturlaws
Resident Rockstar
Resident Rockstaryour code could look something like this
Downward =
CALCULATE (
COUNTA ( 'PMS_COMPLAINT'[MATERIAL_ID] ),
FILTER ( ALL ( 'PMS_FINANCIAL_PDS' ), MAX ( [p-value] ) <= 0.05 && [TAU 1] < 0 )
) + 0
But, are '_Measures'[p-value] a variable in this measure? It is not part of the code you posted.
Sorry. Miss read your question Yes they both are variables.