How to sum data in column A , where ID is distinct and for specific value in column B

[alienout]

ID	Column A	Column B
1	10	Document
1	10	Document
2	12	Solution
2	12	Solution
2	12	Solution
3	20	Document
3	20	Document
3	20	Document

My table has duplicates. 

how do I sum values in column A, for a "Document" in column B ?
So, the formula returns 30. 

also, looking to count distinct ID's for "document".  Formula returns 2. 

[Ritaf1983 · Accepted solution]

Hi @alienout 
For sum please use a measure :

Sum unique =

CALCULATE(

SUMX(

SUMMARIZE('Table','Table'[ID],"max",MAX('Table'[Column A ])),[max]),FILTER('Table','Table'[Column B]="Document"))

For count:

Count unique =

CALCULATE(

COUNTX(

SUMMARIZE('Table','Table'[ID],"max",MAX('Table'[Column A ])),[max]),FILTER('Table','Table'[Column B]="Document"))

Pbix is attached

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

[alienout]

Thank you 

@Ashish_Mathur @Ritaf1983 

both solutions are working out for me. 

[Ashish_Mathur]

You are welcome.

[Ashish_Mathur · Accepted solution]

Hi,

PBI file attached.

Hope this helps.

[Ritaf1983 · Accepted solution]

Hi @alienout 
For sum please use a measure :

Sum unique =

CALCULATE(

SUMX(

SUMMARIZE('Table','Table'[ID],"max",MAX('Table'[Column A ])),[max]),FILTER('Table','Table'[Column B]="Document"))

For count:

Count unique =

CALCULATE(

COUNTX(

SUMMARIZE('Table','Table'[ID],"max",MAX('Table'[Column A ])),[max]),FILTER('Table','Table'[Column B]="Document"))

Pbix is attached

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly