Problemns with IF logic VAR
Hello everyone, who are you guys doing? I am preparing a comparative dashboard about two dev platforms and encountered a logical problem. Basically, I have to apply a conditional logic within DAX which I thought would be easy. Every time I filter a value (visual filter) on the page, it will perform a calculation by taking fixed values and multiplying them by the value selected in the filter. So, hypothetically speaking, if my Project A does not have available data, I have to perform this calculation for it: (Fixed Jenkins Median / Fixed Azure Median) * Filtered project median value. The measure was implemented as follows: if the calculation needs total values from both platforms, and when I filter by project, I created a VAR for the total of Azure and Jenkins but FIXED, so I can derive the values by division. VAR for acronyms and VAR totals were also created to perform the other calculations. Has anyone done something similar and can help me? Here is the DAX with logic: // CONDITIONAL VAR JenkinsResult = IF( ISFILTERED(dGeneral[Acronym 2]), IF( ISBLANK(FilteredJenkinsMedian), (FixedJenkinsTotalMedian / FixedAzureTotalMedian) * AzureAcronymMedian ), TotalJenkinsMedian ) VAR Platform = SELECTEDVALUE(dGeneral[Platform]) // SWITCH VAR FinalResult = SWITCH( Platform, "Azure", TotalAzureMedian, "Jenkins", JenkinsResult ) RETURN FinalResult
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.
