Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Having issues after creating relationship

After creating the calendar table, I created a relationship with another data table. But while creating tabular visual some of the rows are missing from the data. For Example: If my data table contains 30 rows of data, I am able to visualize only 26 rows.

Without creating relation also I am getting less number of rows what I have in the report.

Please help me with this issue asap.

Need Help
Show and Tell
Tips and Tricks

7 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    6 years ago

    Anonymous , In case of 1-M, Assume 1 side is master table.

     

    If show data with Fact table (On many side) then it will only show the data from the master which present in Fact table.

     

    If you want all rows of the master you need to add +0 to the measure

     

    Like count(Fact[item]) +0

    or use this option

     

    Another reason could be not having the same name on both sides because of Case or white space. Clean those things up

    Item1 and Item 1 or  "Item 1 "

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      I tried. I have removed the relationship also to check if all data is coming from the master file. The issue is from master itself it is showing 26 rows instead of 30 rows. 

      • amitchandak's avatar
        amitchandak
        Super User
        6 years ago

        Anonymous , do you have duplicate values , if yes by default those will shown distinct values in most of the visuals

        Can you share screenshot

        Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.