Forum Discussion

Libin7963's avatar
Libin7963
Helper II
1 year ago
Solved

Display blank row in Matrix table

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.             ...
Need Help
  • bhanu_gautam's avatar
    bhanu_gautam
    1 year ago

    Libin7963 , Also check if this is enabled or not

     

     

suparnababu8's avatar
suparnababu8
Super User
1 year ago

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!