Forum Discussion
Helper IIYou can't create a relationship between these two columns because one of the columns must have uniqu
Hello, don075 ,
the issuse is that you don't have any match, because you have different formatting:
Trns:BridgeTable
Crumb
if I create temporary one, it works just fine:
Helper III have attached the report. recreated the report with ImportData. My original report was created with DirectQuery. This thread won't let me upload the file. I am including the google share link to the file.
https://drive.google.com/file/d/163e3hhTqZaL-7Z-BfbRFC8N_hPNxdSJ5/view?usp=sharing
Super UserHello, don075 ,
the issuse is that you don't have any match, because you have different formatting:
Trns:
BridgeTable
Crumb
if I create temporary one, it works just fine:
- don075
Thanks a lot. Silly mistake by me. I had to make one more change to the relationship.
In the link between BridgeTable and Trns, had to select "Both" for "Cross filter direction"