Divide function is showing blank results

Hi Anonymous,

Thanks for your reply.

I have updated the approach to calculate the defect density now, but still no luck. Here is the new formula and sample data.

DefectDensity =
CALCULATE(
DIVIDE(
CALCULATE(
DISTINCTCOUNT(VR_DefectsManster[TestDefID]),
VR_DefectsManster[TestDefStatusText] IN {"Defect Correction in Process", "In Process", "Information Required", "Solution Proposal", "Forwarded", "Tester Action", "Wait for Defect Correction", "Confirmed", "Build Blocked", "New"}
),
CALCULATE(
COUNT('VR_PlanTesterTable'[Merged-UniqueID]),
VR_PlanTesterTable[StatusGrouping]IN {"Pass", "InProgress", "Fail"}

)))

Table - VR_PlanTesterTable

Table 2 - VR_DefectsManster

Thanks again 🙂