Forum Discussion

Helper I

5 years ago

Solved

Issue with creating a table visual from related tables.

Hello, I have an issue with creating a relationship between three tables. First let me introduce you to the data model. We have 3 tables: (Please note Primary keys are used for something e...

Need Help

Kumail
5 years ago
Hello jellyjoe

Sample .pbix file is attached for your reference.
https://drive.google.com/file/d/121sNOM_K4cHRRP6bWrJUJSwKJvS2OA-8/view?usp=sharing

Regards
Kumail Raza
Did this help? Kudos are appreciated
Consider Accepting it as the solution to help the other members find it more quickly

jellyjoe

Helper I

5 years ago

Hello Kumail

The key is Line+Conveyor connector and Machine which are matched to each other using the Conv_MC_Relations table.

The logic is that we know that machine X and conveyor Y have a relation, then we get times of stops from conveyors and time of stops of machines and compare them looking for certain events.

The measure i wrote is correct, those are the events that I'm looking to see 1 being the event happened, 0 being the event didn't happen.

My main issue is i don't know how to display that data in a form of a table showing something looking like that:

line + Conveyor connector	Conv stop start	Conv stop end	Caused by Machine
AM1 CONV12	2021-06-24 09:00:44	2021-06-24 09:03:04	MC1 (or blank if no match)

The way of determining ..caused by machine" would be the measure 1 being caused by machine and 0 not being caused by it.

Sorry if my explanation is a bit chaotic, if You have any more questions please let me know.