Forum Discussion
Relationship between multiple tables
Ticket_Table is a dimension table, not a fact table
the relationship to Ticker is the wrong way round.
Next, you made assumptions about VALUES that turn out not to be true
Let's fix that
Now we're talking. At this point I don't know what the business relationship is between Ticker and Trial - you need to explain that.
Ticket_Table is a dimension table, not a fact table
the relationship to Ticker is the wrong way round.
Next, you made assumptions about VALUES that turn out not to be true
Let's fix that
Now we're talking. At this point I don't know what the business relationship is between Ticker and Trial - you need to explain that.
Hi,
Thanks for your reply! Understandably I'm a novice to Power BI. So please bear with me...
The business relation between Event, Ticker and Trial is this - Let's ignore the table "Ticker" for now. Trial table contains all the trials that were conducted in a country with the associated Ticket. You could have multiple Trials inside each ticket - (same person receiving multiple trials but associated with one bill). If an issue arises during the Trial, then an entry is made inside the Event table. Event table contains all the events that happened in a specific country on a specific date. Basically, whatever accident/issue happened during a trial is captured in Event table under a unique event number. Each event has an related Ticket to it. So the ticket inside "Event" is a subset of the Tickets inside the table called "Trial".
What I want to do is do an analysis of how many events happened vs number of Trials vs No of Tickets vs which country vs Date.
For instance, how many issues happened in Andorra in 2024 compared to the number of Tickets or the trial efficiency (viz., no fo events/No fo Trials).
I'm looking into the file you sent!
Thanks!