DUBLICATE VALUES

[ANM_97]

Hello everyone!

I'm trying to calculate the value of the guarantees. I have this situation: A client can have only one guarantee, regardless of the number of loans. How can I calculate the total value of guarantees without multiplying their value?

Example:

CUSTOMER_ID	LOAN_ID	COLLATERAL_VALUE
100	A	1000
101	B	1200
102	C	1500
103	D	200
103	E	200
104	F	1500
105	G	500
105	H	500
TOTAL:		=1000 + 1200 + 1500+ 200 + 1500 +500  =5900

Thank you for help!

[amitchandak]

@ANM_97 , Try a measure like

sumx(Values(Table[CUSTOMER_ID]), max(Table[COLLATERAL_VALUE]))

or

sumx(Summarize(Table[CUSTOMER_ID],"_1", max(Table[COLLATERAL_VALUE])),[_1])

[Greg_Deckler · Accepted solution]

@ANM_97 If I understand correctly, I believe you want:

Measure = 
  SUMX(
    SUMMARIZE('Table',[Customer_ID],"__Average",AVERAGE([Collateral_Value])),
    [__Average]
  )

[Pragati11]

Hi @ANM_97 ,

You can simply create a measure:

totalCollateralValue = SUM(tablename[COLLATERAL_VALUE])

thanks,

Pragati