Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Greetings,
I have a two tables, one that is imported(Products), the other is DirectQuery(Lignes_A). There is a many to one relationship (Lignes_A being many and Products being one). I'm trying to use the related function to get the value "family" that is in Products. Related even recognize the products table as a related table, but once I valid the Dax, it says it isn't possible because these tables arent related.
From what I could gather, this is basically an issue that's been going around for a year now. How can I go around this issue?
Here's the Dax query I've come up with (which was working while I still had everything on import, but due to size is not a viable option):
And here's an image of my relationships. I highlighted the foreign keys. Does anyone know what I can use instead of Related, as it is not working?
it seems there are at least 4 tables used here:
'LIGNES_A'
'PIEDS_A'
'reporting SupplierRebatesRules'
'Products'
plus whatever table is being used in [TOT_NET_HT]
Can you add sample tables (in format that can be copied to PowerBI) from your model with anonymised data? Like this (just copy and paste into the post window).
Column1 | Column2 |
A | 1 |
B | 2.5 |
Maybe there is a way to achieve the same result without using RELATED, but in order to see if it's possible I would need to see the data
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
42 | |
21 | |
21 | |
14 | |
13 |
User | Count |
---|---|
43 | |
39 | |
33 | |
18 | |
17 |