Display blank row in Matrix table

[Libin7963]

I have two tables as below 

Table 1

Table 2

As you can see below the matrix table is not showing C, Is it possible to display C with value 0.

[suparnababu8]

Hi @Libin7963 

Create a DAX measure  as mentioned below

FinalID = 
SUMX(
    'Table A',
    VAR RelatedID = MAXX(
        FILTER('Table B', 'Table B'[Name] = 'Table A'[Name]),
        'Table B'[ID]
    )
    RETURN IF(ISBLANK(RelatedID), 0, RelatedID)
)

Then Drag Name  column from Table A into Rows  field

then drag FinalID  measure into Values  field

Then you'll get the output as you required. 

Hope this helps you.

Thanks!

[bhanu_gautam]

@Libin7963 , Try this

Click on the matrix visual to select it.
Go to the "Format" pane.
Expand the "Values" section.
Turn on the "Show on rows" option if you want to display rows with no data.

[Libin7963]

Thanks for youre reply, are you referring to the option below, if so it is not helping. 

[bhanu_gautam · Accepted solution]

@Libin7963 , Also check if this is enabled or not

[Libin7963]

Thanks, that almost worked, is it possible to show 0 for blanks