Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi All
My AR table customer table unable to link with my SOURCE table.
i using this expression to link :-
I get below error msg :-
Column '' in Table '' contains blank values and this is not allowed for columns on the one side of a many-to-one relationship or for columns that are used as the primary key of a table.
Can some one advise me how to clear the error msg ?
Sample PBI file :-
Paul
Solved! Go to Solution.
Hi @admin11 ,
The reason for the error is that this column contains null values.
Result after filtering out blank values
Customer = DISTINCT(UNION(ALL(AR[Customer/Vendor Code]), filter(all(SALES[CUST_ID]),[CUST_ID]<>BLANK())) )
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @admin11
Try this:
Customer = DISTINCT(UNION(values(AR[Customer/Vendor Code]), values(SALES[CUST_ID])) )
If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
LinkedIn: www.linkedin.com/in/vahid-dm/
New Year Power BI eCard:
https://community.powerbi.com/t5/Data-Stories-Gallery/Happy-New-Year/td-p/2266398
Hi @admin11 ,
The reason for the error is that this column contains null values.
Result after filtering out blank values
Customer = DISTINCT(UNION(ALL(AR[Customer/Vendor Code]), filter(all(SALES[CUST_ID]),[CUST_ID]<>BLANK())) )
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
User | Count |
---|---|
91 | |
73 | |
68 | |
63 | |
55 |
User | Count |
---|---|
96 | |
89 | |
73 | |
61 | |
58 |