Combine two measures with conditions in AGGR function

msshawn3019 — Fri, 18 Mar 2022 23:43:15 GMT

This does not work

Aggr(RangeAvg([Debit SE Score],({<[Debit-IHC IND]={'1'}>} [Credit SE Score])), Segment)

I need to aggregate all [Debit SE Score] and only [Credit SE Score] where [Debit-IHC IND] is true. The value of the 2 measures should sum and display by "Segment"

These 2 lines of code work separately, but I need to combine the aggregated average

Aggr(Avg([Debit SE Score]), Segment)

Aggr(Avg({<[Debit-IHC IND]={'1'}>} [Credit SE Score]), Segment)

Re: Combine two measures with conditions in AGGR function

msshawn3019 — Sat, 19 Mar 2022 00:40:55 GMT

I've self-resolved this... hope it helps someone. Place RangeAvg around the 2 Aggr functions.

RangeAvg(

Aggr(Avg({<[Debit-IHC IND]={'1'}>} [Credit SE Score]), Segment),

Aggr(Avg([Debit SE Score]), Segment))

topic Combine two measures with conditions in AGGR function in App Development

Combine two measures with conditions in AGGR function

Re: Combine two measures with conditions in AGGR function