How to create filters for slicer?

[Mer333]

Hello everyone!

I just recently started to use PP and it works great! But DAX formulas became really a problem for me because mechanics quite different from standard excel.
That's why I really need your help if it won't be too difficult.

I have 2 text columns (actually there are much more but in this task only two will be needed). Structure allows the situation when one unique value in the first column has a few different values in the second column. I mean this will be a few rows, but value in the first column will be the same.

In the current task I have to create a slicer with 4 filters for the fisrt column:
1) If for unique value of 1 column do exist both two values "text1" and "text2" it should be category 1.
2) If for unique value of 1 column does exist value "text1" but no "text2" it should be category 2.
3) If for unique value of 1 column does exist value "text2" but no "text1" it should be category 3.
4) If for unique value of 1 column doesn't exist neither value "text1" nor "text2" it should be category 4.

Which function should I use and how?

 

[Mer333]

You are completely right. There is more than just lookup. In the real task I have tons of unique values instead of clearly understandable food column. And I have no idea what is the category for each of this values according to my requirements. So that’s why I really need a stronger solution than just a lookup.

Also, if you can't understand "why" categories is marked like this, you can look at the first post here where I left parameters for this request.