Total Overall Value and Individual Value using the same Measure. How to divide them
Hi All. I'm kind of stuck here. Need your help on this. My problem is the measure used to get defect count and total defect count is the same, to differentiate it is using Plant (a column). I want to calculate defect count weightage as per formula below: Defect count weightage = defect count / total defect count The total defect count is the row that I highlighted in the screenshot. How to get that value if it's using the same measure? Here is the measure used to calculate the defect count. DefectCount = SUMX(FILTER(Joined_FactAIVC,Joined_FactAIVC[DefectClass]<> "Produced Glove" && Joined_FactAIVC[DefectClass]<> "Good Glove" && Joined_FactAIVC[DefectClass]<> "Empty Link" && Joined_FactAIVC[DefectClass]<> "System Status"),[Value]) Kindly help.
