Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
CrisJR
Frequent Visitor

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.

 

 table.png

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!

0 REPLIES 0

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.