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

5 Replies

  • bhanu_gautam's avatar
    bhanu_gautam
    Super User
    1 year ago

    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's avatar
      Libin7963
      Helper II
      1 year ago

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

       

  • 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!