show items with no data with use relationship?

[ksaranraj5]

Hi, 

I'm not getting values in userelationship same as active relation ship when I'm using use items with no data option on dimensions in chart

I'm creating a table visualization through active relationship like below

in dimension values I have enabled the show items with no data like below

When I'm using the userelation dax instead of active relationship, I'm getting table like below

after enabling the show times with no data, it works like it's nt responding to use relation ship

How to achieve same result as active relationship while enable the show items with no data

please find the power BI app for your reference

https://gaininsight-my.sharepoint.com/:u:/g/personal/saranrajk_gain-insights_com/EWBwB6DPYL5MjaPgZKO... 

[ksaranraj5]

@amitchandak  I think combines values works same as mergine two columns that I have already done it on transformation. I have used that only on userelathion 

[amitchandak]

@ksaranraj5 ,

You should  create a column like this both tables: order and customer, 1-M active join, and then try

Join key = COMBINEVALUES("-", [customer id], [order id])