A lot of IF and OR statements - Making it run slow
Hi all, I am having some issues with the performance of some of my reports, due to some measures running slow. Some base info: I am connected to an Azure Blob Storage, collecting data in CSV format. I do some cleaning using Power Query The measure(s) in question: Newsletter Permissions For my company there are some different criteria a recipient have to have, in order to be have a newsletter permission, and they are: If any of the following are true: IF( [ComplaintCheck]=1 || [LastEmailCheck]=1 || (It's more than 365 days since you last got an email) [MalformedCheck]=1 || [ValidEmailCheck]=1 || [UnsubscribedCheck]=1 ) OR if ALL of the following are true or BLANK: IF( Created more than 365 days ago First use of app is more than 365 days ago Your last app use is more than 1000 days ago Your last interaction is more than 1000 days ago Your last web use is more than 1000 days ago Your permission is set within the last 365 days ) For all of the above I have made a seperate measure looking like this: IF( OR( NOT(SUM('agillic-targetgroup'[Days Since First Use])<365), SUM('agillic-targetgroup'[Days Since First Use])=BLANK() ) ,1 ,0 ) I have used Power Query to created columns that calculate how many days it has been since the different dates. I can provide a sample set if needed. I hope some of you can help.