Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Using columns from different tables in a visual table

I have created 2 tables within Power Bi. For both tables: product & position are the same. 'Reference' has a column called Measurement, which represents the different types of measurements to...
Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

    So what I did was manage the relationships so that the columns which where in both tables would have a relationship. 

                                                        I'd say they are working properly, but I encountered another issue when trying to reach my end goal. 

    I wanted to somehow have a final results column somewhere on the page sort of like the one below (that one doesn't work though)Basically what I want to do is compare resultA, resultB, resultC, and resultD and if they are all "PASS" I want the resultFINAL column to output "PASS" 

Anonymous's avatar
Anonymous
Not applicable
7 years ago

So what I did was manage the relationships so that the columns which where in both tables would have a relationship. 

                                                    I'd say they are working properly, but I encountered another issue when trying to reach my end goal. 

I wanted to somehow have a final results column somewhere on the page sort of like the one below (that one doesn't work though)Basically what I want to do is compare resultA, resultB, resultC, and resultD and if they are all "PASS" I want the resultFINAL column to output "PASS"