Forum Discussion
Time Specific Events
Hi everyone, I am having trouble to create a solution that allows me to identify the top three contributing factors to a machine stop. The only events I would like to consider are events that hap...
Hi amitchandak,
Thanks so much for your quick response.
Unfortunately, your code does not present the desired results. Here is what I entered:
Measure 1 = CALCULATE(COUNTROWS(Table1),FILTER(Table1, Table1[Time] >= NOW() - TIME(6,0,0) && Table1[Machine] = "Machine 2"))
Top Events = CALCULATE([Measure 1], TOPN(2, ALLSELECTED(Table1[Event]), [Measure 1], DESC), VALUES(Table1[Event]))
When I put the the "Top Events" measure in a table together with the column "Event", I get the error code: "Can't display the visual."
I tried to understand your code bit by bit and I am not sure if it would display what I am trying to figure out. Just to clarify, I am trying to find the most popular events in Machine 1 & 3 that appeared 6 minutes before the stop event in Machine 2.
Please see below a link to the mock dataset:
Please see below a link to my current Power BI working file:
Again, thank you for your help.
Julius