Ok, here is the problem, I think this is easy but just didn't figure out the solution by myself.
I have two tables, which are related by Object. My problem is TABLE 1.
In TABLE 1 the Object can get four kind of status:
3. Approved OR Rejected
I would like to add a column to TABLE 1 (green RESULT column below) which gives the number 3. result for all rows within the same Object. So when I select an object in visualization, it gives me immediately the information if the Object is Approved or Rejected. I could also use that as a filter to search rejected objects.
This gives me the result I was hoping to get. BUT, I am still wondering how to create a slicer of this (i.e. if I want to see only rejected objects). Anyway, I will close this thread now and maybe return the second issue later if needed.
Thank you @darlove !!! It works now and I marked your reply as a solution. I am not prof enough to understand which actions slow down the code.
I also solved the slicer problem. For some reason if I used this new column as a slicer, it didn't work how I wanted (with info from other table), but when I brought the result to another table (where is only one object per row) it started to work. Thank you anyway! :-)
__DAX is simple but is NOT easy__. There are many caveats and intricacies that will put people in difficult and hard-to-understand situations very often (unless they know exactly how DAX works) but there's always, ALWAYS, a logical explanation of what you see and it follows the rules to the very last letter.
Be prepared for that but do not get discouraged There's always a way to get what you want.