Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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)
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))
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))