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.
Hi all,
I have two tables, say TBL_MANY and TBL_ONE.
There exists a many to one relationship, which is active and cross filter is defined both ways.
Filtering from the one to the other works in the report page.
However, when I create a rather trivial new calculated column in TBL_MANY:
No your not missing anything about the functions. It should work. Try deleting the relationship and set it to single filter direction. Then try again. Moreover, in my experience, when people use related, they are often trying to do something that can be done a better way. There is no need to add a column in the many table as that is what the relationship is for.
Hi Matt,
thanks for the quick reply!
I tried that (delete entirely and reconnect + single direction), including disactivating and re-activating, but to no avail. Do you think this might be a bug? I just installed a new PBI version (64 bit) only yesterday...
I understand this trivial example makes no sense, but its what I ended up with while debugging. In reality I use RELATED() in a measure where I select rows in TBL_MANY in row context before aggregation, based on some criterium using variables in both tables.
Can you please put a file with this issue somewhere on a cloud drive (OneDrive, Google Drive, Dropbox) and post a link to it? When doing it, please set the right read permissions.
Thanks.
Best
Darek
I would (have), but my data is sensitive. I also cannot replicate the problem from two simple test tables with manual input, even though I see no difference with my case. I'll see if I can trim down and/or map out the senistive stuff while still keeping the problem.
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 |
---|---|
47 | |
26 | |
19 | |
14 | |
10 |
User | Count |
---|---|
58 | |
50 | |
44 | |
19 | |
19 |