Semi Additive

system · May 30, 2019, 12:18am

Hello All,

Does anybody ever worked on semi-additive measures? I’ve heard of them, but never needed to use them until now.

I’m working on a report where i have to do a sum of distinct miles on two dimensions. The attached file has sample date and the output i’m looking to get.

I’d be interested to hear any thoughts.
Semi Additive.xls (9.0 KB)

Praveen8367 (BOB member since 2010-11-27)

system · May 30, 2019, 5:20am

Have you tried using calculation contexts - ForEach / ForAll

Is miles as dimension rather than a measure

all these things may point you in the right direction

BarkyBaloo (BOB member since 2007-07-04)

system · May 30, 2019, 3:28pm

This might do it depending on whether the values are fixed etc

=Sum([miles] In ([DESTINATIONSYSTEMNAME];[miles]))

Ross_BOXI (BOB member since 2018-04-17)