Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Quick Measure to Generate Average correct figures

I have created a Quick Measure which I think should work but it doesn't. I selected the division option and put the count of points in the first part (I don't recall there being an option for another option like Sum, Average or Maximum. Similar for the second part where I selected Site Team Count.

 

Count of Points by Site divided by Count of Number of Teams =
DIVIDE(
    DISTINCTCOUNT('Site Team Count'[Points by Site]),
    COUNTA('Site Team Count'[Number of Teams])
)
 
I want to be able to show the average points by team in a Table.
 
 
What should my quick measure be to achieve this?
Need Help
  • V-lianl-msft's avatar
    V-lianl-msft
    5 years ago

    Hi Anonymous ,

     

    Try to create a measure like this:

    Measure = CALCULATE(AVERAGE('Table'[points]),ALLEXCEPT('Table','Table'[Site]))

     

     

    Best Regards,
    Liang
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

5 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    5 years ago

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

     

    Why distinct count ?

     

    Count of Points by Site divided by Count of Number of Teams =
    DIVIDE(
    COUNT('Site Team Count'[Points by Site]),
    COUNTA('Site Team Count'[Number of Teams])
    )

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      When creating the quick measure I didn't see the option to select something other than count - maybe I should look a little closer.

      • amitchandak's avatar
        amitchandak
        Super User
        5 years ago

        Anonymous , You can create a measure. Need to quick measure? and what is formula need is more important

  • V-lianl-msft's avatar
    V-lianl-msft
    Community Support
    5 years ago

    Hi Anonymous ,

     

    Try to create a measure like this:

    Measure = CALCULATE(AVERAGE('Table'[points]),ALLEXCEPT('Table','Table'[Site]))

     

     

    Best Regards,
    Liang
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.