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:
Solution SupplierIf you drop your user table and leave your 2 fact tables remaining why not join those 2 together in your database (or SQL, or in power query) to save all this messing about. But as someone has already stated, you do not have any unique keys to join users and fact. Is there a reason you cannot have a user key in your fact tables?
FYI - from info above the reason your slicer is not the behaviour you want is because you have used sMonth from 1 fact table (the other fact table has no relation with the other), your slicer should be using a value from your bridge table if you want it to filter both fact tables.
Helper IIThanks for the reply. I cannot link this in my database as there are duplicates on both tables. I thought maybe powerbi will let me view crumb data when clicked on Trns table, even with duplicates.
I have been developing reports with Crystal reports for years and doing this there is so simple, even with duplicates. But the users want this done in powerbi.