Forum Discussion

Rads2929's avatar
Rads2929
Frequent Visitor
5 years ago
Solved

Pie Chart with Avg

Hello, I am trying to implement a Pie Chart with the sample data below. Legend: Color and Values: Average of Days. The problem is that there are records that have the same color mutilpe times so when...
Need Help
  • jdbuchanan71's avatar
    jdbuchanan71
    5 years ago

    Rads2929 

    Try this.

    Avg = 
DIVIDE( SUM ( 'Table'[Days] ), DISTINCTCOUNT('Table'[ID]) )

     

     

vanessafvg's avatar
vanessafvg
Icon for Community Champion rankCommunity Champion
5 years ago

You could do something like this, although it is rather simplistic.