Column contains blank values and this is not allowed

[Anonymous]

I am new to PowerBI and I am getting this message. I don't even know where to look for this since I don't actually have a column called Casters 2. I disabled all relationships and still get the error. This column will actually have blank values since not all of our chairs will have casters. Please help.

[v-ljerr-msft]

Hi @Anonymous,

Have you tried the solution provided by @MFelix above? Does it work in your scenario? If it works, could you accept it as solution to close this thread?

If you still have any question on this issue, feel free to post here. 

Regards

[MFelix · Accepted solution]

Hi @Anonymous,

When you do relationship in the PBI you can have active or inactive relationships this makes the use of the relation between both tables to be applied diretcly on your measures and visuals or need to use a USERRELATION formula to use it (for example). In your case you.need to delete the relationship were the Casters 2 column is used (not disable it) or take the blank rows out.

Regards,
MFelix