max

[Anonymous]

Hello, I m trying to set show latest production stage process from "tjob" table, "secondnumber" column to main order table "MrpTableAll".

Relation is made by PO. Tjob (many) > mrptableall (one).

Any thoughts? If you need more inf., wirte it down.

[Anonymous]

2 columns with numbers, 1 columnn with text

Adding +1 value into ProductNumber column slicer from "MRPTableAll" eliminates the empty row but the the origin is still unknown. 

[Anonymous · Accepted solution]

Ok, i managed to solve it using dax, max and ALLEXCEPT but I m having first empty row with the highest number from all and total also with highest number

Cant see dont sum option anywhere

[tamerj1]

what is there in the rows of this matrix?

[Anonymous]

"tjob" table, "secondnumber" column is production stage, defined by a number. Doesnt matter is its calculated column or dax expression as long it works. Production stage has to be filtered by production order. "Tjob" table, "primerNumber" column

There are multiple entries for the same production stage and production orders, devided into smaller quantity processes

it can be calcuted column or dax expression

[tamerj1]

Hi @Anonymous 

is it a calculated column that you're trying to calculate?

which column contains the production stage? In which table?

which column shows the stage order? In which table? Is it the same production stage column ?

which column