I got into Power BI a week ago and I have been having some troubles with it.
I got a simple Excel database composed by Operative Systems, Servers, Number of the Error and Error Level.
Every machine has errors and it can either be one of the levels (4 or 5) or it can has both errors.
In my power BI matrix i got to have an option or something that whenever i select it will only display the machines that own both errors. All the other ones should disappear.
I will link both excel and power bi examples to make it easier to understand the problem.
It should only display this ones: