Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Dim Table contains hidden blank value?

Hi there Could anyone please help me understand why I am seeing this completely blank row when I choose to 'show items with no data' using a column from my dim table     There are no blank ...
Need Help
  • v-janeyg-msft's avatar
    v-janeyg-msft
    4 years ago

    Hi, Anonymous 

     

    This screenshot alone can't tell that there is a problem with your real data. You need to check your fact table column.

    Are they a one-to-many relationship? Is there other relationships between these two tables besides this column? 

Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
4 years ago

Hi,

In the Priority code column of your Fact Table, there is atleast one blank or there is an entry there which is not in the Priority code column of the Dimenstion table.

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi Ashish_Mathur 

    This was the first thing I checked and there are no discrepancies there. Therefore am trying to figure out what has caused this as that is not the reason

     

    Here is the fact table data extracted into Excel. All the values in the Priority Code column match the values in the Dimension table. 

     

    • Ashish_Mathur's avatar
      Ashish_Mathur
      Icon for Super User rankSuper User
      4 years ago

      Hi,

      I am not sure then.  I will need to see the PBI file.