Aggregate from parent is blank when child is blank

[DCELL]

I have a parent-child tables set up using this relationship, where the child table is missing a few records, but the parent is not missing any. CRM = parent, CPQ = child.

In a table visual, I'm not able to show SUM( CRM[Esimated Value] ) for all rows as you can see below. Even though CRM[Estimated Value] is not missing any values, it is showing blank if the child record is blank:

How can I obtain the result below? Although it is possible to join them in Power Query, which is how I got the result below for demonstration, I prefer not to do so.

In addition to the problem above of the blank [CRM Value] values, I also don't understand why the table display changes when the column are in a different order.

When CRM.Quote Number is the first column, then the layout is like this:

But when CPQ.Quote number is the first column, then the blanks disappear:

[DCELL]

@lbendlin this is the result:

And the measure code is CRM Value = SUM( CRM[Estimated Value] )

[lbendlin]

Enable "Show items with no data"

[loerie]

@lbendlin commenting from my other account which allows file sharing. Here is the sample file I'm working from https://drive.google.com/file/d/1fVDAjM3h-zmrvgMV-odduNgBjg0kbgNh/view?usp=sharing.

When filtering direction is single from CRM->CPQ, then 'show items with no data' has no visual effect.

[lbendlin · Accepted solution]

Remove Quote Number CPQ from the visual.

Or use a CALCULATE function to get it back.

Here is some background on why this is happening.

AutoExist and Normalization - SQLBI

See attached.

[lbendlin]

change the filter direction to single, from CRM to CPQ.  Show the code for the "CRM Value" measure.