Forum Discussion
Two Tables, Nothing but Zeros
Hi All, I've been staring at this issue and need a second set of eyes. I've got two tables, TABLE1 a parent table with unique values and TABLE2 with values I need to slice and work with. What I...
alexei7
Continued Contributor
Continued ContributorHi,
Presuming that you've joined both table by the "Loc#" field, you could just bring in "Loc#" from the parent table and "location name" from the location table into a Power BI table visual and then filter the visual to only show where "location name" is blank.
No that is not working (that was the first thing I did), I'm using the locations from the Table 1 and trying to tie the values into Table 2, but you're seeing a simplified version of the data. There's a lot more complexity here that is likely causing the problem, but I've sort of stared at this for so long I can't see the answer.