Forum Discussion

CornelisV's avatar
CornelisV
Icon for Helper IV rankHelper IV
1 year ago
Solved

Missing observation not in table view visible

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

Need Help
  • Tahreem24's avatar
    Tahreem24
    1 year ago

    CornelisV  Create a calculated column in "Required Table" like below and use this in Slicer:

    NewSample = LEFT(RequiredTable[SampleID],1)

     

     

     

7 Replies

  • Tahreem24's avatar
    Tahreem24
    Icon for Super User rankSuper User
    1 year ago

    CornelisV  Create a calculated column in "Required Table" like below and use this in Slicer:

    NewSample = LEFT(RequiredTable[SampleID],1)

     

     

     

    • CornelisV's avatar
      CornelisV
      Icon for Helper IV rankHelper IV
      1 year 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's avatar
        CornelisV
        Icon for Helper IV rankHelper IV
        11 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's avatar
    danextian
    Icon for Super User rankSuper User
    1 year 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's avatar
      CornelisV
      Icon for Helper IV rankHelper IV
      1 year 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's avatar
        danextian
        Icon for Super User rankSuper User
        11 months ago

        I used the diemensions from the one side of the relationship - required table