Having issues after creating relationship

[Anonymous]

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.

[amitchandak]

@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]

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]

@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.

[Anonymous]

This is my sample data. In this, some of the rows are not coming at the front end part.

[Anonymous]

To be in particular only three specific rows I am not able to visualize and all data corresponds to it.

[amitchandak]

@Anonymous ,

Put these in a table visual and make both of them unsummarized

https://docs.microsoft.com/en-us/power-bi/create-reports/service-aggregates in that pop there is an option for that

Second, if you have a join date with another table, check does your date has a timestamp. By changing datatype to date time and use a format having time.

If you have timestamp then create a join with date field

Date new = [Date].Date

[Anonymous]

I have kept it on don't summarize option only.

Within the master data only, if I am having 30 rows, all rows are not coming with respect to any columns. Few rows are missing out. I have never seen such issues.