Forum Discussion
Relationships between tables
Hi everyone, Please help me with the solution as I am a beginner in Power BI. I am getting data from an online SharePoint List. Where Incident is Main List and Person and Witness are sub-lists. So...
Hi Anonymous,
Your relationships should be:
- Incident ID -- * to 1 -- Person
- Incident ID -- * to 1 -- Witness
Make sure that both the relationships have a single directional cross filter.
Did I answer your question? Mark this post as a solution if I did!
Consider taking a look at my blog: Forecast Period - Previous Forecasts
Hi Shaurya ,
Thanks for the reply, can you please elaborate more on Incident ID of which table,? as mentioned earlier the Incident ID ( Incident table is unique )
- Incident ID (incident) -- * to 1 -- Person
- Incident ID (incident) -- * to 1 -- Witness
This cardinality is invalid.
1. Incident ID (Incident ) --1 to many --> Incident ID (Person )
2. Incident ID (Incident ) --1 to many --> Incident ID (Witness)
But when creating a table while adding all the columns from 3 tables I get the below error.