Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

max

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's avatar
    Anonymous
    3 years ago

    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

5 Replies

  • tamerj1's avatar
    tamerj1
    Community Champion

    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 

  • Anonymous's avatar
    Anonymous
    Not applicable

    "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

  • Anonymous's avatar
    Anonymous
    Not applicable

    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's avatar
      tamerj1
      Community Champion

      what is there in the rows of this matrix?

  • Anonymous's avatar
    Anonymous
    Not applicable

    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.