Forum Discussion
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...
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
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