Forum Discussion

OAlvarezGarcia's avatar
OAlvarezGarcia
New Member
7 years ago

lastest value

  Hello,   I am trying to get the output of units from the last machine in this case the formula will say for article 23442111114 total output (QuGood) 1087 units. The total output needs to be cal...
AkhilAshok's avatar
AkhilAshok
Solution Sage
7 years ago

How about this:

Latest TS = MAX('Table'[ManStartTime])

Latest QuGood = 
VAR RankedMarchines =
    ADDCOLUMNS (
        SUMMARIZE (
            'Table',
            'Table'[MachineCode],
            'Table'[Article Number],
            'Table'[QuGood]
        ),
        "Rnk", RANKX (
            ALL ( 'Table'[MachineCode], 'Table'[QuGood] ),
            [Latest TS],
            ,
            DESC
        )
    )
VAR FirstRankMarchine =
    FILTER ( RankedMarchines, [Rnk] = 1 )
RETURN
    MAXX ( FirstRankMarchine, 'Table'[QuGood] )