Dear all, I'm trying to make the table view visible after combining tow tables:Table Measure contains the Samp, ID and Measured values. Table Required contains the teh required ID that must be measured: I have used the Model View and link the columns Sample-ID between two tables. The results of table view is here visible: As you may see: a row is missing: it does not have Sample-ID "B-DQ" because it was not in table Measure (was not measured). How can I make this visible in table view despite it was not measured?Appreciated your support, Best regards, CornelisV

CornelisV Create a calculated column in "Required Table" like below and use this in Slicer: NewSample = LEFT(RequiredTable[SampleID],1)

Missing observation not in table view visible

7 Replies

Tahreem24
Super User
10 months ago
CornelisV Create a calculated column in "Required Table" like below and use this in Slicer:

NewSample = LEFT(RequiredTable[SampleID],1)
- CornelisV
  Helper IV
  10 months ago
  Hello Tahreem24 ,
  
  That is a different approach, I have tried this and no result, unfortunately:
  
  There is a difference between your screenshot: A Blank is displayed in the Slicer visualization.
  Any explanation what is making things differently?
  
  Best regards,
  
  Cornelis
  - CornelisV
    Helper IV
    10 months ago
    Hi Tahreem24 ,
    
    I think this is the best solution, you need the next Model Virew to enable:
    Many to one, Cross filter both
danextian
Super User
10 months ago
Hi CornelisV

When add a measure to a visual and the measure returns blank, Power BI automaticall hides the blank rows to improve performance. You can force Power BI to return a nonblank value by adding +0 to the existing measure - for example: [sum of sales] + 0. This will force zeroes when the values are blank but this can cause a performance issue on large tables and/or return unexpected results. A better approach would be to enable "show items with no data"
- CornelisV
  Helper IV
  10 months ago
  Hi danextian ,
  
  I'm afraid that this will not lead to the solution.
  The option "Show items with no data" is something that I have already tried, but it will not help in my case. The Model View is here defined:
  
  I have surely ticked on "Show items with no data", but the result is still the same
  
  Any explanation what is making difference between yours and mine result?
  
  Have a great day,
  
  Cornelis
  - danextian
    Super User
    10 months ago
    I used the diemensions from the one side of the relationship - required table