Forum Discussion
Calculate Defect Rate
Hello, I've 2 tables. TABLE 1: Defect Data Table ITEM Qty 1A 8 2A 4 3A 4A 5 5A 6A 6 7A 6 TABLE 2: Item Receive Data Table Item Qty ...
You should be able to do something like:
Measure =
VAR __table2 = FILTER('Table17',NOT(ISBLANK([Qty])))
VAR __table3 = ADDCOLUMNS(__table2,"__defects",SUMX(RELATEDTABLE('Table16'),[Defects]))
VAR __table4 = FILTER(__table3,NOT(ISBLANK([__defects])))
RETURN
DIVIDE(SUMX(__table4,[__defects]),SUMX(__table4,[Qty]),0)