Power BI get one value from duplicates

[Anonymous]

Hi there,

I do have data as followed...

Reference Number     Amount     

A123                               100

A123                                100

A123                                100

A124                                 200

A125                                 300

--------------------------------

Total                                800

I would like to have data as showed in the below

Reference Number     Amount     

A123                               100

A124                                 200

A125                                 300

--------------------------------

Total                                600

Thank you

[Anonymous]

Hi there,

I do have data as followed...

Reference Number     Amount     

A123                               100

A123                                100

A123                                100

A124                                 200

A125                                 300

--------------------------------

Total                                800

I would like to have data as showed in the below

Reference Number     Amount     

A123                               100

A124                                 200

A125                                 300

--------------------------------

Total                                600

Thank you

[v-juanli-msft · Accepted solution]

Hi @Anonymous

If you want to change the dataset model, you could go to Edit queries->Home->remove rows->remove duplicates.

If you want to keep your original table and get a table structure like this to build a visual.

You could create a new table with this formula

Table 2 = SUMMARIZE(ALL('Table'),[number],[amount])

Table        Table2

Best Regards

Maggie