Forum Discussion

Saravanan_ameer's avatar
Saravanan_ameer
Frequent Visitor
3 years ago
Solved

Percentage for selected value

I have the table which contains columns like request status (OPEN,CLOSED,ONHOLD,CANCELLED), Request ID, Created date   Now i placed the slicer for the date range so if i select the date range i wan...
Need Help
Show and Tell
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    3 years ago

    That's cool, I think you should use switch statement rather then this nested if statement to reduce the complexity and performance of the measure like this.
     Test = switch(Request_Table[Request Status],"Closed","Completed","Resolved","Completed","Cancelled","Completed","Open or On Hold") 
    OR
    if(Request_Table[Request] IN { ,"Closed","Resolved","Cancelled"} ,"Completed" , "Open or On Hold")

    This will improve your dax performance alot.


    If my response helps you a bit then do hit the like.


Anonymous's avatar
Anonymous
Not applicable
3 years ago

That's cool, I think you should use switch statement rather then this nested if statement to reduce the complexity and performance of the measure like this.
 Test = switch(Request_Table[Request Status],"Closed","Completed","Resolved","Completed","Cancelled","Completed","Open or On Hold") 
OR
if(Request_Table[Request] IN { ,"Closed","Resolved","Cancelled"} ,"Completed" , "Open or On Hold")

This will improve your dax performance alot.


If my response helps you a bit then do hit the like.