Forum Discussion

MacarenaGB's avatar
MacarenaGB
Icon for Helper II rankHelper II
5 years ago
Solved

Different total result with Averagex

Hi everyone!

 

I am trying to get get a total of a measure which should make the average according to "Descripción" column. 

I need that the result sum 17,27 instead of 5,73.

Can anyone help me? TIA!!! 🙂

Need Help
  • amitchandak's avatar
    amitchandak
    5 years ago

    MacarenaGB , Try a measure like 

    Measure = Sumx(VALUES('Avg For Csv'[Descripción]), CALCULATE(AVERAGE('Avg For Csv'[Total])))

3 Replies

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    5 years ago

    MacarenaGB , Try a measure like 

    Measure = Sumx(VALUES('Avg For Csv'[Descripción]), CALCULATE(AVERAGE('Avg For Csv'[Total])))
  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    5 years ago

    MacarenaGB , what is logic of 17.27

    May be Divide([Total], count(Table[Description])

    or

    Divide([Total], distinctcount(Table[Description]))

     

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

    • MacarenaGB's avatar
      MacarenaGB
      Icon for Helper II rankHelper II
      5 years ago

      Hello

       

      I tried it but it doesn't work:
      Let me attach the table

      Descripción,Total
      Gasto A,10
      Gasto A,12
      Gasto A,12
      Gasto A,14
      Gasto A,10
      Gasto B,3
      Gasto B,3
      Gasto B,3
      Gasto B,3
      Gasto C,2
      Gasto C,3
      Gasto C,2
      Gasto C,3
      Gasto C,3
      Gasto C,3

       

      Thanks!