Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

dax

p3m = var a= MAX('PSR'[Month])-2 var b =CALCULATE(DISTINCTCOUNT('PSR'[Customer_Code]),'PSR'[Month]>=a && 'PSR'[Month]<=MAX('PSR'[Month])) return b this is the formula for the above visual...
Need Help
Uzi2019's avatar
Uzi2019
Community Champion
2 years ago

HI Anonymous 
Please do the following steps:
Create new measure:

 

Cust>0 = CALCULATE(COUNTROWS(Customer),FILTER(Customer,Customer[Retailing]>0))
 
Create new measure 

Cummuative =
Var N= MAX(Customer[Month])-2
Var A=CALCULATE(Customer[Cust>0],'Customer'[Month]>=N && 'Customer'[Month]<=MAX('Customer'[Month]))
Return A

 

 

I hope I answered your question.

 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    works 100% just 1 condition that i need is sum(retailing) and then distinctcount of customers. i got this result earlier also it is not wrong just after sum of retailing is applied then the count comes out to be different. ALso im not able to add this "sum of retailing" in the above measure

    • Uzi2019's avatar
      Uzi2019
      Community Champion
      2 years ago

      Hi Anonymous 
      Can you give me example by smapled data how you want Sum (retailing) to be added??
      On which condition ?
      or is it different measure or what?
      Initially you want the count(cust) whose retailing >0 right. then you want 3 months count together.

      Please mention the condition properly