Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I am attempting to determine where in my facility a particular run is currently at.
I have multiple tables generating from different systems and I have created relationships between these tables. I assumed that I could put the values into a matrix and they would cross filter, however, I am always getting the max value of the entire related table as opposed to the max value of the rows which include the Run #.
Run Location Status | Prod Run Table | Expected Result | Actual Result | |||||||
Location | Status | Run | Run | Status | Run | Status | ||||
A | 1 | 123 | A | 123 | 3 | 123 | 4 | |||
B | 2 | 123 | A | 125 | 4 | 125 | 4 | |||
C | 3 | 123 | B | |||||||
D | 4 | 123 | C | |||||||
125 | A | |||||||||
125 | C | |||||||||
125 | D |
Any Idea's?
I would make the following Measure:
MaxStatus = CALCULATE( MAXX( ProdRunTable, RELATED( RunLocationStatus[Status] ) ), ALLEXCEPT( ProdRunTable, ProdRunTable[Run] ) )
Here are the tables / columns I made and the result:
That ended up giving me the same thing that I have been getting, however I do believe that I found a solution.