Categorizing a column value into 3 different categories

Hello,
Here is a suggestion :
You can do a Group By with Concatenation as exlained here :
https://gorilla.bi/power-query/group-by-to-concatenate-text/

Then create a conditional column with a Text.Contains to get the final result.

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

Hi monishamathew ,

I am sending the measure sample I created with the screenshot.

MEASURE = IF(calculate(DISTINCTCOUNT('Table'[New Column]),GROUPBY('Table','Table'[App]))>=2,"Both",SELECTEDVALUE('Table'[New Column]))

 

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

Best regards 🙂