Forum Discussion

marchn's avatar
marchn
Icon for Helper I rankHelper I
2 years ago
Solved

SUM attendees with duplicate values

Hello all   I have been so grateful for the support I've received from this forum since I embarkd on my Power BI journey a month or two ago. I've learned so much, but still SO much to learn. I woul...
  • audreygerred's avatar
    audreygerred
    2 years ago

    Hello - instead of creating the average column, create the below measure:

    Total Attendees = SUMX(DISTINCT(Table[ID]),FIRSTNONBLANK(Table[Attendees], 0))
     
    I get the below:

     

    Hope this helps! Have a great day!

marchn's avatar
marchn
Icon for Helper I rankHelper I
2 years ago

Hello audreygerred - thank you so much! That works perfectly! Really grateful. Natasha