Forum Discussion
Solved
Filtering ranked row by latest/highest
Hi all, I am having trouble with filtering a data table based upon a row rank. What i am trying to achieve is to be able to visualise only the latstes rows with the highest row rank, this b...
Hi IscaacNewton , Try this:
RESULT =
CALCULATE ( MAX ( Table1[Rank column] ), ALLEXCEPT ( Table1, Table1[Iordernumber] ) )
If this helps, then please hit the thumbs up & mark it as a solution. Thanks.
Latest = MAX(Rank Column)
Hi and thanks for the quick reply.
In that scenario it gives me the max of all and not per colum Ordernummer. See below
Hi IscaacNewton , Try this:
RESULT =
CALCULATE ( MAX ( Table1[Rank column] ), ALLEXCEPT ( Table1, Table1[Iordernumber] ) )
If this helps, then please hit the thumbs up & mark it as a solution. Thanks.How could I have not thought about this. Thank you so much! For later reference; i had to adjust your fix a little bit to allign with the naming. See below
RESULT = CALCULATE ( MAX ( Query1[Row Rank] ), ALLEXCEPT ( Query1,Query1[OrderNUmmer]))