Need to create a function to Categorize values

hi, Anonymous, MarkS, zayan

When you use the POWERBI the functions are similar because the concept is different. In Excel you work with cells to calculate calculations and in POWREBI you work with tables.

With this the functions in the POWERBI must be written attending the concept of tables.

Come on....

1. Import your data with the TICKETID and INTERATION column;
2. Create a [QtResolution] measure to count tickets with interaction equal to Resolution;

QtResolution = CALCULATE(COUNTROWS(DADOS);FILTER(ALL(DADOS[Interaction]);DADOS[Interaction]="Resolution"))

3. Create a [QtResolved] measure to count tickets with interaction equal to Resolved;

QtResolved = CALCULATE(COUNTROWS(DADOS);FILTER(ALL(DADOS[Interaction]);DADOS[Interaction]="Resolved"))

4. Create a [QtInfoClient] measure to count tickets with interaction equal to Requested Info from Client;

QtInfoClient = CALCULATE(COUNTROWS(DADOS);FILTER(ALL(DADOS[Interaction]);DADOS[Interaction]="Requested Info from Client"))

5. Create a [StatusInteration] measure to set the ticket STATUS.

StatusInteration = if(
 and(
 ([QtResolution]+[QtResolved])>0;[QtInfoClient]>0
 );"OurSide";"ClientSide"
 )

Attention with the texts of the interactions (Resolution, Resolved, Requested Info from Client) if it changes you must update the measures.

Here's how it was on the table.

Please try and test using it. And please mark the right reply as answer if your issue has been resolved, otherwise, please feel free to ask if you have any other issue.

Best Regards,
Rfranca