calculate the number of customer with negatif sales variation

[Sofinobi]

good morning all,

please,

i have a measure to calculate the variation of sales by month;

Sales Variation = DIVIDE([Sales],

                    CALCULATE([Sales],DATEADD(Date[Date],-1,MONTH)),0)-1
now, i want to calculate the number of costomer that have a negatif Sales Variation (decrease), also if it's possible, display their names in a table.

thank you

[tamerj1 · Accepted solution]

Hi @Sofinobi 

please try

Count Negative =
SUMX ( VALUES ( Customer[Customer ID] ), INT ( [Sales Variation] < 0 ) )

[Sofinobi]

thank you so much my friend, it works perfectly, this way i dont need to create a calculated column.

thanx again