The ‘test’ value is a calculated field - ‘percentOfTotal(count(fraudmethodchild),[{Impact Framework - Other}])’ - with Impact Framework - Other being a nested calculated field - ‘distinct_countIf(caseid,contains({Impact Framework},“Other”))’
If this is the use case, then we can calculate the denominator and then write another calculated field to find the distribution %.
Step 1: calculate Numerator (this is already done by you)
Step 2: calculate denominator - Total case with impact framework other
totalcase = distinctcountover(ifelse(impact framework=‘Other’,caseid, null),,pre_Agg)
Step 3: find ratio from numerator and denominator
%total = count / avg(totalcase)