Aggr Expression

[Anonymous]

Can't identify where am I going wrong here!

Each ratio that belongs to DQ name should be compared with Threshold  of DQ Name and count how many satisfied.

if(Aggr((sum({<[LOB={'CMB'}>}[Rule Met Count])
/sum({<[LOB]={'CMB'}>}[Total Count])),[DQ Name])>aggr(only(Threshold),[DQ Name]),count([DQ Name]))

[sunny_talwar]

May be you need this

=Count(Aggr(If((Sum({<[LOB={'CMB'}>}[Rule Met Count])/Sum({<[LOB]={'CMB'}>}[Total Count])) > Only(Threshold), [DQ Name]),[DQ Name]))

[Anonymous]

This result varies with LOB =CMB selection and with out CMB .

[Anonymous]

Thresholds are different for each DQ Name, will different thresholds apply to each result of Sum({<[LOB={'CMB'}>}[Rule Met Count])/Sum({<[LOB]={'CMB'}>}[Total Count])) ?

[sunny_talwar]

Not sure I understand, do you have a sample you can share maybe?

[Kushal_Chawda]

may be this

sum(Aggr(count(if(Aggr((sum({<[LOB={'CMB'}>}[Rule Met Count])
/sum({<[LOB]={'CMB'}>}[Total Count])),[DQ Name])>aggr(only(Threshold),[DQ Name]),[DQ Name])),[DQ Name]))

[Anonymous]

never mind, I made comparison on backend. Thanks