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
Ahmedx's avatar
Ahmedx
Super User
2 years ago

why is this range not included in your formula?

Anonymous's avatar
Anonymous
Not applicable
2 years ago

oh my bad you can include everything

  • Ahmedx's avatar
    Ahmedx
    Super User
    2 years ago
    Measure 2 = 
var a= MAX('PSR'[Month])-2
var b =CALCULATE(DISTINCTCOUNT('PSR'[Customer_Code]),'PSR'[Month]>=a && 'PSR'[Month]<=MAX('PSR'[Month])&& 'PSR'[sale]>0)
return
b
    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

      this measure is fine but not 100% correct. after taking sum of retailing then the distinct count should be applied.

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        2 years ago

        Ahmedx ?