
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Nested Aggregations
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


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
It would be helpful to see your two functions...

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
You can use
If(Column(1) > Column(2), 1, 0)
And make total function as "Sum"
Please close the thread by marking correct answer & give likes if you like the post.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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)
)
