Table Column Showing All Possible Values

[maxc89]

Hello, I am having an issue with a table, picture attached, where the Housing Type column is showing all the values each individual could possibly have (5), even though each individual (ID column) is only assigned one housing type. This is causing the data in the table to duplicate and show five rows per individual, instead of one row per ID number. When I pull Housing Type out of the table it reverts to one row per ID. The data comprising the table is split between two separate data sets with housing type coming from one set and most other data coming from another, and connected by the ID column. Any and all help would be greatly appreciated.

[Syndicate_Admin]

Don't @maxc89,

Could you share some sample data or a dummy .pbix file to test? Delete sensitive information.

Reference: How to provide sample data in the Power BI Forum - Microsoft Power BI Community

Best regards

ice cream

[Syndicate_Admin]

Don't @maxc89,

Could you share some sample data or a dummy .pbix file to test? Delete sensitive information.

Reference: How to provide sample data in the Power BI Forum - Microsoft Power BI Community

Best regards

ice cream

[Syndicate_Admin]

Don'@maxc89,

Could you share some sample data or a dummy .pbix file to test? Delete sensitive information.

Reference: How to provide sample data in the Power BI Forum - Microsoft Power BI Community

Best regards

ice cream

[Icey]

Hi @maxc89 ,

Could you share us some sample data or a dummy .pbix file to test? Please remove sensitive information.

Reference: How to provide sample data in the Power BI Forum - Microsoft Power BI Community

Best Regards,

Icey

[jdbuchanan71]

The problem is the model not being able to apply the filtering between all the tables becuse of filters flowing from the one to the the many and not the other direction so it is giving you all possible combinations.  Can you add a column in your primary table where you bring over the Housing Type based on the ID?