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...
this measure is fine but not 100% correct. after taking sum of retailing then the distinct count should be applied.
Ahmedx ?