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
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 ?

  • Ahmedx's avatar
    Ahmedx
    Super User
    2 years ago

    I don’t understand, please explain what else is needed

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    the retailing value are + and - both .......in this case if some retailing is done lets say 20 then naturally the count should be 1 but the product he recieved were damaged so he returned those products i.e -20. technically that customer had never ordered. +20-20= 0 . so it should not be counted. but in this case in power bi when we exclude -ve retailing at that time only -20 is excluded and +20 remains there. so still that customers count is considered. and in excel that is not the case. In excel it is taking the sum of retailing and then the count is being taken. i want the excel value.

  • Ahmedx's avatar
    Ahmedx
    Super User
    2 years ago

    Please check attached pbix for more details.

     

     

  • Ahmedx's avatar
    Ahmedx
    Super User
    2 years ago

    Hello! did you check my file