Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreShape the future of the Fabric Community! Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions. Take survey.
Dears
I am creating a PowerBI file with a few tables directly connected with our system.
Basically I have Commercial Budget (many) and Item Master (one). Both are linked by using the item code.
The point is that Master Item has a column named "Family", the purpose of this field is to create a simpler clasification to analyze sales (instead of multiples codes, we wrap them in families for better analysis).
I have created a query with that column, covert to Table, arrange, rename and remove duplicates
The "funny" thing is when I try to create a relathionship between the new query "Family" with Commercial Budget, a message telling me is not possible because no "uniques values in any table" appers.
How is this possible? Why can't PowerBI recognize the new Query "Family" as single values after removing duplicates?
I could use related but I want a different design...
I hope you may help 🙂
Regards,
Dears
Just checking my MasterFile, I found out we have some items without Family assigned (they appear blank)
¿Could this be the reason?
Hi @Ciria,
>>Just checking my MasterFile, I found out we have some items without Family assigned (they appear blank)
Yes, multiple blank value will cause the issue.
In my opinion, you can remove these blank value at power query or create a new table with distinct column value and add the relationship between new table and original tables.
Regards,
Xiaoxin Sheng
Hi @v-shex-msft
I have created this new column:
Column = CALCULATETABLE(DISTINCT(vSP_ArticulosAll[Family]))
The following message is returned: A table with multiple values was supplied where a single value was expected.
Awaiting for your support.
Hi @Ciria,
Can you share some sample data? I will try to build relationship on it and share the updated sample.
Regards,
Xiaoxin Sheng
Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.
Check out the November 2024 Power BI update to learn about new features.
User | Count |
---|---|
94 | |
90 | |
83 | |
76 | |
49 |
User | Count |
---|---|
145 | |
140 | |
109 | |
68 | |
55 |