Forum Discussion
% Sales contribution calculation Weekly
The context of where you use the measure will be important. Because of the "ALLEXCEPT" line, if you give it a context where both JAN and FEB exist in the same context, your denominator is going to be JAN + FEB.
I'd expect you'd want to use this measure on a table where you have row contexts for JAN and FEB separately.
If you are selecting a context where JAN and FEB are both present, how are you expecting to aggregate the output? Like if Jan was 99% and Feb was 90%, what total value would you expect your measure to produce?
Anonymous
Now using your measure,
Upon multiple year selection, the sum of % contribution of Jan & Dec Individually is not 100%.
Instead, it is 100% upon summation of both months.
Expectation: % contribution sales of Jan should be 100% and Dec should also be 100% contribution.
The context of where you use the measure will be important. Because of the "ALLEXCEPT" line, if you give it a context where both JAN and FEB exist in the same context, your denominator is going to be JAN + FEB.
I'd expect you'd want to use this measure on a table where you have row contexts for JAN and FEB separately.
If you are selecting a context where JAN and FEB are both present, how are you expecting to aggregate the output? Like if Jan was 99% and Feb was 90%, what total value would you expect your measure to produce?