Forum Discussion

crispybits77's avatar
crispybits77
Icon for Helper I rankHelper I
2 years ago
Solved

Limiting table visual to records in a single source

I have a table visual that draws from two different source data tables. For simplicity with an example the source tables look like this:   Source1: Emp ID Name Source2: EmpID Name of Pet ...
Need Help
  • hackcrr's avatar
    hackcrr
    2 years ago

    Hi, crispybits77 

    Thank you very much for your reply. I think you can try him. Additionally, you can create a relationship for two tables and put one of the ID columns into table visual to get a similar effect:

    I prefer to build relationships, which will optimize performance.

     

     

    Best Regards,

    hackcrr

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

hackcrr's avatar
hackcrr
Icon for Memorable Member rankMemorable Member
2 years ago

Hi, crispybits77 

Based on your description, you could create a new Calculated Table or Calculated Column, use DAX to merge the two tables, and make sure to select only those EmpIDs that exist in both tables.

Here are the two source tables I used:

I created a calculation table using the following DAX expression:

Merged Table = 
FILTER(  
    NATURALLEFTOUTERJOIN('Table', 'Table1'),  
    NOT ISBLANK('Table'[Name of Pet])  
)

Use this new Merged Table in the table visual object:

 

 

 

Best Regards,

hackcrr

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.