Forum Discussion

roberts_stats's avatar
roberts_stats
New Member
3 years ago
Solved

Sum a column with duplicates

How many apples are there at each Farm (with DAX)   Farm Barrel Apples   Taster    Vote North Farm      Green Barrel      150 John Sweet    North Farm Green Barrel 150 Sue Swee...
measure
  • v-easonf-msft's avatar
    v-easonf-msft
    3 years ago

    Hi, roberts_stats 

    You can consider add a summarized table to remove the duplicates records and keep the valid record columns.

    Calculated Table:

    Table 2 = SUMMARIZE('Table','Table'[Farm],'Table'[Barrel],'Table'[Apples])

    Then you can perform calculations based on this summary table.

    From the summary table you can easily tell how many apples are there at each Farm.

    Best Regards,
    Community Support Team _ Eason

v-easonf-msft's avatar
v-easonf-msft
Icon for Community Support rankCommunity Support
3 years ago

Hi, roberts_stats 

You can consider add a summarized table to remove the duplicates records and keep the valid record columns.

Calculated Table:

Table 2 = SUMMARIZE('Table','Table'[Farm],'Table'[Barrel],'Table'[Apples])

Then you can perform calculations based on this summary table.

From the summary table you can easily tell how many apples are there at each Farm.

Best Regards,
Community Support Team _ Eason