Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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
Solved! Go to 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.
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.
Hi, Actually you want to show percentages in the kpi rather than the whole total, right?
Yes I got the outpu by using the IF fucntion i created the column
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
User | Count |
---|---|
91 | |
89 | |
79 | |
69 | |
68 |
User | Count |
---|---|
222 | |
128 | |
117 | |
82 | |
77 |