topic Re: calculate the number of customer with negatif sales variation in DAX Commands and Tips

calculate the number of customer with negatif sales variation

Sofinobi — Sat, 03 Jun 2023 11:39:14 GMT

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

Re: calculate the number of customer with negatif sales variation

tamerj1 — Sat, 03 Jun 2023 13:59:52 GMT

Hi Sofinobi

please try

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

Re: calculate the number of customer with negatif sales variation

Sofinobi — Sun, 04 Jun 2023 08:24:15 GMT

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

thanx again