Trying to Create conditional Column or formatting based on performance

[izzu]

Trying to Create conditional Column or formatting based on Ticket handel (performance) in a Metrix Tabel

Condition should be if - Ticket Assigned No - is More , Breach Ticket No - is Less , Ticket Open No - is Less , Ticket Closed - is more , Work order - is More , SR Created - is Less - Should be Good , then fair , and Poor

Assigned to	Ticket Assigned No	Breach Ticket No	Ticket Open No	Ticket Closed	Work order	SR Created	Performance
Lucy	10	2	1	9	0	3	Fair
Sam	15	8	2	13	2	8	Poor
Rakesh	25	4	1	24	5	2	Good
Pamela	2	0	0	2	15	0	Good

[v-stephen-msft]

To be honest, I don't understand your real needs, @izzu .

I can only see that you want to create a conditional column named Performance.

The Performance column is based on the countings of the previous columns.

I would like to ask you to explain in detail what constitutes Fair, Poor, and Good in the Performance column.

For conditinal calculating, we often use IF() or SWITCH() to return results.

IF function (DAX) - DAX | Microsoft Learn

SWITCH function (DAX) - DAX | Microsoft Learn

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[izzu]

Hi Bmejia , let me try to put another way , in my Metrix visula I have column Agents name and Count of Tickets assigned and ticket status count handel by them (i.e.. Ticket Assigned Count, Breach Ticket Count , Ticket Open Count  , Ticket Closed , Work order , SR Created ) I need to create Performance Column based on tickets handeled , and createria should be based on the Ticket Count and Status Count ( i.e.. Least Breach Ticket , Least Open Ticket , Least Created Ticket, High Assigined Ticket, High Work Order , High Closed Ticket - will Good and Fair and Poor)

[Bmejia]

I am sorry, but I still don't understand how you get to your performance of good, fair and poor.   If somebody understand Izzu please help out.  a example of how you calculate each of the performace would be helpfull do you compare values and give it a score or you multiply or subtract values etc..

[Bmejia]

Hi Izzu,
You need to provide more information on your calculation.  you telling us that "Ticket Assigned NO  - is more",  more/less then what value? What makes something to have a fair, poor or good performance?