Need to sum the unique values from another table

[Anonymous]

Hi Experts,

I want to sum the unique values (means remove duplicates) from another table comparing columns.

The value should be 258847.

Please help me on this.

Regards.,

Swamy

[v-jingzhang · Accepted solution]

Hi @Anonymous 

Does every pair of Year and Business have only one distinct Budget value? If so, you can create a new table with below code to summarize data from the original table, then sum data from this new table. 

New Table = SUMMARIZE('Budget Table','Budget Table'[Year],'Budget Table'[Business],"2021 Budget",MAX('Budget Table'[2021 Budget]))

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.

[tamerj1]

@Anonymous 

What do you refer to when you say "another table"?

For the sample table you are providing you can do

measure =

SUMX ( DISTINCT ( TableName ), TableName[2021 Budget] )

[Anonymous]

@tamerj1 

I want the dax for calculated column and compare two columns from both tables.

Regards.,

Swamy