Forum Discussion

Analitika's avatar
Analitika
Icon for Post Prodigy rankPost Prodigy
6 years ago

Divide wrong result

In table i have formula   DIVIDE ( 'Table'[Summ] ; 'Table'[Count] )   i need same measure, AVERAGEX( Table; DIVIDE( Table[Summ]; Table[Count] )  )   return wrong result. How to get...
Need Help
Tips and Tricks
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi Analitika ,

 

What kind of error do you get?Does below dax expression work?

 

measure =AVERAGEX(
ALL(Table);
DIVIDE(
Table[Summ];
Table[Count]
) 
)

 

If not,could you upload some sample data with expected output?

 

 
Best Regards,
Kelly
Did I answer your question? Mark my post as a solution!
  • Analitika's avatar
    Analitika
    Icon for Post Prodigy rankPost Prodigy
    6 years ago

    it is no errors, just wrong results,

    as in table it is
    Sum(Summ)/Sum(Count)  ' devided each row

    but in measure ir became

    Sum(Sum(Summ);Sum(Count)) / n  ' devided rows sum

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Hi Analitika ,

       

      Based on my test,the result is same with measure= Sum(Summ)/Sum(Count)  ' devided each row.See below:

      Table as below:

      Then measures are as below:

       

      Divide = DIVIDE(SUM('Table'[Value]),COUNT('Table'[Value]))
      Average = AVERAGEX('Table','Table'[Divide])

       

      And you will see:

      I'm not sure whether I misunderstood your point,if yes,pls correct me and advise me what your expected output is with my data.

       

      Much appreciated.

       

       
      Best Regards,
      Kelly
      Did I answer your question? Mark my post as a solution!
      • Analitika's avatar
        Analitika
        Icon for Post Prodigy rankPost Prodigy
        6 years ago

        please try to add 6 numbers after comma