Formula PPM

[Anonymous]

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

[Anonymous]

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])

[tamerj1]

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