Forum Discussion
Optimise measure performance
Hi there, I’m experiencing some considerable delays when applying a measure to my dashboard report – it can take up to 2 minutes for the data to load when using this measure so I wanted to ask if...
obothewizard , also check if contains string can work you
if 'Wifi Signup' contains Account ID
Wifi & Tickets = CALCULATE(DISTINCTCOUNT('Wifi Signup'[Contact_Name__c]),
FILTER('Wifi Signup',
CONTAINSSTRING('Wifi Signup'[AccountId], 'Wifi Signup'[Contact_Name__c])))
Hmm that formula does not work, it can't recognise the [AccountID] field -
Test same day =
CALCULATE(DISTINCTCOUNT('Wifi Signup'[Contact_Name__c]),
FILTER('Wifi Signup',
CONTAINSSTRING('Tickets',[AccountId], 'Wifi Signup'[Contact_Name__c])))
Plus I need to get the corresponding ID count from the ticket table existing also in Wifi so not sure contains string is the right formula here? Am a total newbie though so could well be wrong on this...