Find Uptrading/Downtrading customers

[iluvfnky]

Hi,

I'd like to be able to distinctly count how many of my customers are trading up against last year and trading down against last year. The customer is customer code and I'm trying to use the % Var measure however it doesn't seem to be working for me.

Any ideas,

Thanks

 

[sheetspread]

http://www.mrexcel.com/forum/excel-questions/961882-calculate-pivot-table-variance.html

See post #7

 

[iluvfnky]

Thank you but I'm looking for a Dax Measure

 

[sheetspread]

Oh right, sorry:

https://sqldusty.com/2015/09/01/10-dax-calculations-for-your-tabular-or-power-pivot-model-part-1/

(also #7)

 

[iluvfnky]

Great thank you, however I have have a similar measures that calculates the nett variance. What I want is a measure that will give a total of accounts that are trading positively based on the variance or trading negatively.

Thanks

 

[sheetspread]

(forget what I just wrote here if you saw it)

 

[sheetspread]

Here's how I counted positive year over year customer changes: