Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Stop Tables Removing Empty Values

Hi,

 

I'm hoping this should be quite straightforward.

 

When you normally add Values to a Matrix table from a different data table (Enrollments table) than the Rows (People table), the Rows that don't contain any data in the Enrollments table get removed.

 

See below the actual data I'm working with:

 

BEFORE

People table - 119 people

 

 

AFTER

People table with ID added to the "Values" from the Enrollments table. The table now has 78 people, therefore there are 41 people who don't have enrollments.

 

 

 

 

Objective:

I want to show all 119 people so I can see the people who do not have enrollments (that is the people from the People table who don't have data in the Enrollments table).

 

Here's the data structure - I'm not using any DAX or measures, just dragging and dropping the fields.

 

 

 

Thanks all!

  • Anonymous Try right-clicking Apps in your Rows field well and choose "Show items with no data".

2 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion

    Anonymous Try right-clicking Apps in your Rows field well and choose "Show items with no data".

    • Anonymous's avatar
      Anonymous
      Not applicable

      Omg that was so easy! I had no idea that was there - thanks so much!!