Forum Discussion

CrisJR's avatar
CrisJR
Frequent Visitor
7 years ago

DAX measure with CALCULATE and FILTER

Hi

 

I have one report with 3 visual filters (date, country and type) and a table that list the stores and number of operatios with the aplied filters. I added a column with the number of operations that meet a condition, but this measure is very slow.

 

 

Here the measure:

Nº operations with conditions = CALCULATE('OPERACIONES'[Nº lines];
FILTER('OPERACIONES';'OPERACIONES'[id_type_sale] = 4 ||
'OPERACIONES'[id_type_sale] = 5 ||
( 'OPERACIONES'[line_sin_origen]=1
|| 'OPERACIONES'[line_fuera_plazo]=1
|| 'OPERACIONES'[line_manual]=1)

))

 

I think that it is slow because the FILTER function is filtering all data in the table (this table has billions of records)

 

How can I improve this measure?

 

Thanks!

No RepliesBe the first to reply