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.
I need help with part of my model.
Part of my model looks like this (the identical column names are the ones related to each other):
My problem is that there are Raw Data entries that don't have an Order ID, but are still important in the visuals, which get filtered out when I use "Line Names" as a Slicer filter in my visualization, beacuse of the current active relationships.
I can solve this by switching the active relationship from Lines-to-Orders to Lines-to-Raw Data.
Unfortunately, my calculated column in the Orders table relies on this current active relationship and looks like this:
Thank you for your reply and you're right, normally I could've.
However, these are DirectQuery tables and LOOKUPVALUE isn't supported in DQ...
I managed to fix it by creating a new summarized table with the necessary columns from the other tables using LOOKUPVALUE and putting the calculated column in there.
It's not pretty, since I now have another table with half of the columns exactly the same as in the Orders table, but it works.
I could change the Orders table from DQ to Import, but the table is quite large and needs to be updated frequently, so I rather not (based on what I've read on DQ vs. import).
Or would you disagree?
I would always go for import where possible. The speed of queries is way better than direct query and you don't get the limitations that DQ introduces.
If your orders table only changes by adding new rows, as opposed to making changes to existing rows, then you could look into incremental refresh if you're concerned about the time taken to do a data load, but Power BI can handle a lot of rows pretty quickly.
It might be an idea to do some tests. Create a version of the dataset which is fully import mode and see how long it takes to refresh the model.
You could use LOOKUPVALUE based on the Line Name.
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 |
---|---|
45 | |
25 | |
19 | |
16 | |
8 |
User | Count |
---|---|
69 | |
48 | |
44 | |
19 | |
15 |