Matrix data show issue

[Anonymous]

Hi All,

I have two tables connected using key (ID+date) & Many:Many(Both).

Matrix shows data when data is available in both tables for any specifc date and not showing any data from both tables if data is not available in one table for any specifc date 

My requirement is show data in Matrix if data is available in atleast one table for any specifc date

Thank. 

Pleae suggest.

[amitchandak]

@Anonymous , use +0 in your measures and try.

[Anonymous]

Since data is only raw data, we are showin any measure. 

Thanks

[v-kelly-msft · Accepted solution]

Hi @Anonymous ,

Click on the drop down arrow in the field of ID>choose"show items with no data":

Best Regards,
Kelly

Did I answer your question? Mark my reply as a solution!