Problem displaying data for 3 tables.

[PKPK90]

I am trying to create a table, Item Master, that will contain data about Items. Most of the data comes from the AR_Inventory table, with an additional two columns coming from the Vendor table. Unfortunately, after adding columns to the "Table" visualization, I only see those that have a relationship. I want to show all the data from AR_Inventory with even empty fields for Vendor where there is no data.

[amitchandak]

@PKPK90 , Based on what I got. Create a measure with +0 and use

or use the option "Show item with no data"

[PKPK90 · Accepted solution]

Thanks. I solved it in a different way. I added a field from the intermediate table (ARINVT_VENDORS) to the visualization and it solved the problem.

Show items with no data - created a crossjoin in my visualization.