Nested Aggregations

[bradley_isaacs]

Good day

I need some help with a possible nested aggregation. 

I have the following :

  1) One measure which has an aggregate function(lets call it A)

  2) Another measure with a normal aggregation (lets call it B)

I want to count (in another measure), how many values in A is greater than the value in B.  See picture below

[Lauri]

It would be helpful to see your two functions... 

[MayilVahanan]

Hi @bradley_isaacs 

You can use 

If(Column(1) > Column(2), 1, 0)

And make total function as "Sum"

[bradley_isaacs]

Thanks for Reply Lauri

A:

SUM(Aggr(SUM({$<[KPI Class ID] = {5}>} [KPI Value]) * SUM({$<[KPI Class ID] = {9}>} [KPI Value]), [%KEY_SHIFT] ))
/
sum( {$<[KPI Type ID] = {5}, [KPI Type]=>}[KPI Value])

B:  IF(iSNULL((Avg({<Config_Description={'SV', 'TA'}>}TARGET_VALUE))), Round($(vTA_Target), 0.01),
Round((Avg({<Config_Description={'SV', 'Technical Availability'}>}TARGET_VALUE) ), 0.01)
)