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]) )

     

     

jdbuchanan71's avatar
jdbuchanan71
Icon for Super User rankSuper User
5 years ago

Rads2929 

Try this.

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