Forum Discussion
Solved
Measure has too long respond time.
I have a report where 1 measure gives me too long repsons time and I can not figure out who to do this better. (result is correct) I have 4 files CAP (fact) and SALES (fact) + date table + C...
elseoutzen , Try like
SUmx(filter('CUSTOMER',[sales FY22]>1||[SALES YTD]>1),[#CAP])
or
SUmx(filter(values('CUSTOMER'[Customer]) ,[sales FY22]>1||[SALES YTD]>1),[#CAP])
amitchandak
Super User
Super Userelseoutzen , Try like
SUmx(filter('CUSTOMER',[sales FY22]>1||[SALES YTD]>1),[#CAP])
or
SUmx(filter(values('CUSTOMER'[Customer]) ,[sales FY22]>1||[SALES YTD]>1),[#CAP])
This works perfect, Thank you so much 🙂 very helpful