Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Formula PPM

Hello,

 

I m trying to write down a PPM  cost measure but i m still failing to do it.

 

= pl master data scrap costs / ( master data closed * costs) * 1 000 000

 

Master data scrap is a source file for product. Stock table for product cost. Master data closed for quantity of manufactured products. Ralatons work, costs are actively working in visual dashboard, as well as maesure for sum of scraps

 

2 Replies

  • tamerj1's avatar
    tamerj1
    Community Champion
    4 years ago

    Hi Anonymous 

    please clarify this equation with column names ans table names and clearly identify the level of aggregation(s)

    = pl master data scrap costs / ( master data closed * costs) * 1 000 000

    provide a clear description of your visual and filters

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    In the master data scrap there is created relationship from column "pn" (product number shortcut, as relation identifiaction) to master data closed, also "pn" column. Master data scrap relation from "pn" column goes to stocktable_dat to "item number" column

     

    I have created working measure for summing up filtered table entries, maybe it ll be helpful

    Cost Price =
    sumx(
    RELATEDTABLE(StockTable_DAT),
    StockTable_DAT[CostPrice])