Percentage for selected value

[Saravanan_ameer]

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 want to see the percentage of the completed requests ad hold requests

example:

for the last month i have total 100 tickets (70 closed,10 resolved,10 is on hold, 9 is cancelled & 1 is open status)

the calculation could be (70+10+9) considered as completed percenatge 89% and the open and onhold should considered as 11% 

Please help to aciheve it in power bi

[Anonymous · Accepted solution]

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]

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

[Saravanan_ameer]

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