Forum Discussion

Analitika's avatar
Analitika
Post 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 same result?
 
 
Need Help
Tips and Tricks

8 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    6 years ago

    Analitika , Ideally it should be sum(A)/Sum(B) or count(B).

    is it something like this >

    DIVIDE (
    sum('Table'[Summ]) ;
    count('Table'[Count])
    )

     

  • 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
      Post 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!