Power bi

[Karthikdiksha]

 @Ruby01  @Rubyavila709 

I have 5 table

Fact table - restuarant -id, city -id, votes , delivery, Takeaway, outdoor dining 

Dimensions table 

City table - city -id , region, latitude, longitude

Restaurant table - Rest-id , name , type, address , ratings, average cost (2) people 

Service table - restuarant- id , services 

( Each restaurant id has many services)

Cuisine table - restuarant id , cuisines 

( Each restuarant id has many cuisines)

relationship

Fact table -> city table - 1 to many relationship 

Fact table -> restuarant table - 1 to many relationship

Fact table  -> service table as well as cuisine table it shows many to many relationship ( because both table have duplicate IDs)

I created bridge table through restuarant-id 

Restuarant table -> service table - 1 to many relationship 

 But my client ask to create bridge table between restuarant table to service table 

( Already 1 to many )

 Is it possible? Any one plz tell 

[amitchandak]

@Karthikdiksha , the Restaurant table  can only join to the fact, if you want to filter other dimensions, you can create measures to do that

refer

How to filter the slicer of a disconnected table: https://youtu.be/cV5WfaQt6C8