Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
117 | |
104 | |
77 | |
73 | |
52 |
User | Count |
---|---|
145 | |
109 | |
108 | |
90 | |
64 |