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

Hi, Actually you want to show percentages in the kpi rather than the whole total, right?

Saravanan_ameer's avatar
Saravanan_ameer
Frequent Visitor
3 years ago

Yes I got the outpu by using the IF fucntion i created the column

 

Completed Status = IF(Request_Table[Request Status]="Closed","Completed",IF(Request_Table[Request Status]="Resolved","Completed",IF(Request_Table[Request Status]="Cancelled","Completed","Open or On Hold")))
 
After that i applied it to the Pie chart and I got the result