Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

wrong averaged weight

I am trying to get a weighted average (as a total), that is, for each customer, :   sum(value * size)     /  sum(size)     Tthe value is just a measure that is (SumPerCustomer / Max_PerCustomer)...
Need Help
amitchandak's avatar
amitchandak
Super User
5 years ago

Anonymous , try to add values and check

 

measure =
var _sel = selectedvalue(Param[Param])
var _cnt =distinctcount(Geography[locations])
var _1= CALCULATE([Sales],TOPN(_sel,all(Geography[locations]),[Sales],DESC),VALUES(Geography[locations]))
var _2= CALCULATE([Sales],TOPN(_cnt,all(Geography[locations]),[Sales],asc),VALUES(Geography[locations]))
return
if(_sel =0 || not(isfiltered(Param[Param])) , _2, _1)


calculate(
SWITCH(

TRUE()

,ISINSCOPE('Customer'[Customer]) , DIVIDE(SumPerCustomer, Max_PerCustomer)

,DIVIDE ( SUMX('Customer', DIVIDE(SumPerCustomer, Max_PerCustomer) * SumPerCustomer), SUMX('Customer', SumPerCustomer),0)

), values('Customer'[Customer]))

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    I can' quiet follow , what do you mean?

    • amitchandak's avatar
      amitchandak
      Super User
      5 years ago

      Anonymous , values is group data at a level

       

      Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.