Forum Discussion

RustyD's avatar
RustyD
Frequent Visitor
2 years ago

Display all rows including empty ones using BRIDGE TABLE

hi,

 

In my model I cannot identify same unique KEY between 2 tables therefore I had to use a bridge table. 
So the part of the model looks like this:

Table1 *-1 Bridge 1-* Table2 

If I am trying to display numeric values from Table2 using measures it works correct and I see populated cells if there is a corresponding value and empty cells if there isn't. 

 

The problem appears when I wanna  add other attributes which are not numeric/measure.

Then It shows only the rows where the relation was found. But I also need to see the empty rows wehre the attribute on the table2 was not found. 

I am loosing this PO where GR was not found.

 

I have tried different configuration of relationship and filter direction but no success. Also option "show items with no data" is not working properly. 

I have noticed that DAX measures like MAX/MIN are working but then I will get only first or last attribute. But unfortunatelly 1 PO can have multiple Confirmations. I was thinking that maybe there is a DAX formula that would bring all rows (all text strings in separate rows) 

Like this expected outcome:

 

 

 

Need Help

2 Replies

  • RustyD's avatar
    RustyD
    Frequent Visitor
    2 years ago

    hi,  amitchandak thanks for the reply.  

    But isn't there any DAX solution to show all text strings in separate rows ?

    Similar like CONCATENATEX but this one is passing all strings to one cell. 

    or

    similar like MAX or MIN but showing all instead ?