Sum unique value in column per category

[MasterSonic]

Hello,

having this table :
Code Group Processing Status

101	Jeans	1	Ordered
101	Jeans	1	Ordered
102	Jeans	1	In Delivery
103	Shirt	3	In Delivery
104	Shirt	3	In Delivery
105	Shirt	3	In Delivery
106	Shirt	3	Sold
107	Shoe	66	Sold

I have this measurment :

Status count per Code = var _status = SELECTEDVALUE('Table'[Status])
var _processing =SUMX(SUMMARIZE('Table','Table'[Group],'Table'[Processing]),'Table'[Processing])
var _t=DISTINCT(SELECTCOLUMNS( FILTER( ALLSELECTED('Table') ,'Table'[Status]=_status) , "Code" , [Code]))
return
IF(_status ="Sold" , _processing , COUNTROWS(_t))

_processing show  70 on it's own- correct,
but with other values just 69, how to get value 70 here?

[tamerj1 · Accepted solution]

Hi @MasterSonic 

please try

Status count per Code =
VAR _status =
SELECTEDVALUE ( 'Table'[Status] )
VAR _processing =
SUMX (
SUMMARIZE ( ALLSELECTED ( 'Table' ), 'Table'[Group], 'Table'[Processing] ),
'Table'[Processing]
)
VAR _t =
DISTINCT (
SELECTCOLUMNS (
FILTER ( ALLSELECTED ( 'Table' ), 'Table'[Status] = _status ),
"Code", [Code]
)
)
RETURN
IF ( _status = "Sold", _processing, COUNTROWS ( _t ) )