DAX formula optimization question

Question

Hi All,&nbsp;I’m trying to implement a DAX column calculation in order to determine if a person is 100% non-billable or partial billable. I have a column in a table which states the ‘Today’s commitment rate’, those values range from 0,00 (a person is non-billable), 0,01 – 99,99 (implies that a person is partial billable) and 100 or greater (a person is fully billable).&nbsp;I'm using the following formula to determine in which category someone belongs:&nbsp;VIP calculation = IF(ISBLANK(Candidate[Todays_commitment_rate__c]); BLANK();
	IF(Candidate[Todays_commitment_rate__c] = 0; "100% VIP"; 
		IF(Candidate[Todays_commitment_rate__c] &lt;100; "Partial VIP"; BLANK())))I'm wonding if anyone can suggest anything that might optimize the formula.&nbsp;Thanks in advance for your help.

anonymous · Accepted Answer

Hi,Are you experiencing performance issues with your current formula? How large is the table where you want to create the new column?Another way to create the desired column could be to try:&nbsp;VIP Calculation = Switch(True();&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Candidate[Todays_commitment_rate__c] = 0&nbsp;;"100% VIP";&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Candidate[Todays_commitment_rate__c]&nbsp;&lt;&nbsp;100&nbsp;;"Partial VIP";&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Blank()&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; )&nbsp;Try and see if the performance is improved.&nbsp;BR,Magnus

Forum Discussion

DAX formula optimization question

2 Replies

Related content

DAX formula optimization question

Optimize Measures

Bookmark questions

If formula

Fabric Cost optimization