Create custom column based on multiple rows

Hi Diego11 

Download example PBIX file with the code below

If you want a solution that might be more flexible in the future and allow you to add more types of issues including adding "sub-types" of work related issues (not just "Work related") you could try this.

The idea is that you assign each type of issue a value:

1 Work related

2 Housing, Mental Health, Domestic Violence

3 [Can be used in the future]

You end up with a column like this 

By your criteria you are only concerned with the type of issue so you can just use distinct values in the Issue Value column

All work related issues = 1

All personal issues = 2

You can sum these distinct values.

If the sum is 1 then they only have work related issues.

If the sum is 2 then they only have personal issues.

If the sum is 3 then they have both issues.

Regards

Phil