Forum Discussion
Using two lookup tables connected with the same fact table
Hi. I have two lookup tables: USER LOOKUP user_id 1 2 3 DATE LOOKUP date 1/1/2018 2/1/2018 3/1/2018 ..connected to a fact table (1-to-many cardinality ...
Hi Anonymous ,
In my opinion,you'd better use user_id from the profile fact table in all your calculations since it's the one-side in the relationship.And since it has a connection with user lookup table,I believe it wont defeat the point of the table.
Check the reference below:
https://docs.microsoft.com/en-us/power-bi/guidance/star-schema
Best Regards,
KellyDid I answer your question? Mark my post as a solution!
Anonymous , I think you want two filters two disconnected slicers. For that take a measure from fact, and check : it is not blank in the visual level filter of the slicer
refer to this video if needed