Price MIX - calculation results from SKUs level to sum up in higher aggregation

[Anonymous]

Hi There,

I am stuck with an issue regarding Price mix.

I created specific mesasures, which indicates wherethere SKU meets following goal:

- both: volume actual and volume budget <> 0

- both: volume actual and volume budget > 0

Result is that i can see MIX on sku level on net sales.

But when i add another aggregation level seems that result is no more calculated on SKU level, but logic is applied to current aggregation, attached screens of the problem and below formulas which i use:

NS/L diff:=IF(AND([Volume]<>0;[Volume Comparison]<>0);[NS/L]-[NS/L Comparison];BLANK())

NS/L greater then zero diff:=if(AND([Volume]>0;[Volume Comparison]>0);[NS/L]-[NS/L Comparison];BLANK())

Mix NS/L:=[NS/L diff]-[NS/L greater then zero diff]

Correct:

Incorrect

Can i kindly ask for help :)?

BR

Patrick

[v-juanli-msft]

Hi @Anonymous 

When i test with my data, it seems all values is 0 for "Mix NS/L".

Could you show me a simple sample for test?

Best Regards
Maggie

[v-juanli-msft]

Hi @Anonymous 

Measure is calcualted based on the rows of the matrix or table visual.

If you delete "material" column from the table/matrix visual, the measure will not calcualte based on the "material" column.

Best Regards
Maggie

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Hi v-juanli-msft,

Did you had time to look at above :)?

Br

Patryk

[Anonymous]

Hi Maggie,

Thanks for the reply!

The thing is that i want to transffer result of logic check from SKU level so i want to see sum of 14 and -17 on sub-brand = -3. On SKU level applied logic is correct and mix is calculated ok.

but when you tick minues on sub-brand on higher aggergation level i do not see any number.

Seems that context change to sub-brand and logic applied calculates incorrect numbers.

How can i transfer result from lower aggergation to higher, so for example i can see -3 on sub-brand instead zero?

BR

Patryk