Good Morning. I write this question because I can not make the intersection of two measurements and calculations. In a dimension that I keep the equipment that there are facts. EquipoCompleto: 101010,101011,101012 (example)
In the other dimension I have the equipment that there is with some failure.
EquipoFallo: 101010, 101009, 101013
What I want is to take the number of teams that have been completed and have had some failure (It would also be worth the equipment that is in the first table that is not in the second.)