Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

DAX formula optimization question

Hi All,

 

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).

 

I'm using the following formula to determine in which category someone belongs:

 

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] <100; "Partial VIP"; BLANK())))

I'm wonding if anyone can suggest anything that might optimize the formula.

 

Thanks in advance for your help.

1 ACCEPTED SOLUTION
magsod
Solution Supplier
Solution Supplier

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:

 

VIP Calculation = Switch(True();

                                       Candidate[Todays_commitment_rate__c] = 0 ;"100% VIP"; 
                                       Candidate[Todays_commitment_rate__c] < 100 ;"Partial VIP";
                                       Blank()
                                 )

 

Try and see if the performance is improved.

 

BR,

Magnus

View solution in original post

2 REPLIES 2
magsod
Solution Supplier
Solution Supplier

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:

 

VIP Calculation = Switch(True();

                                       Candidate[Todays_commitment_rate__c] = 0 ;"100% VIP"; 
                                       Candidate[Todays_commitment_rate__c] < 100 ;"Partial VIP";
                                       Blank()
                                 )

 

Try and see if the performance is improved.

 

BR,

Magnus

Anonymous
Not applicable

Hi Magnus,

 

Thank you very much, the performance increased by adding the Switch functionality to the equation

 

Greetings,

Ronald

 

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.