In Power BI how to handle missing row value on primary value column?

Question

In my table primary key column have missing value, i have tried to fill using measure but it is not work because not full fill the primary key val of column to measure

Answer 1

For handling missing values, you need to follow the following two steps:

1. Replace the missing values with the desired values in Query Editor in Power BI Desktop (optional)
2. Remove the bi-directional relationships and create uni-directional relationships among tables

Note: The direction of the relationship plays a very important role in modeling in Power BI. The direction of the relationship means the way that filter propagates in Power BI. The uni-directional relationship will filter one table based on the other one. Sometimes you need to filter in a different direction, that is when the bi-directional relationship comes into play. However, bidirectional relationship comes with a cost of performance issues. Do not use bi-directional relationships blindly. Make sure you have designed your model in the right way first, and if that doesn’t work, then try other methods such as Cross-Filter DAX functions.