Forum Discussion
DUBLICATE VALUES
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!
Anonymous If I understand correctly, I believe you want:
Measure = SUMX( SUMMARIZE('Table',[Customer_ID],"__Average",AVERAGE([Collateral_Value])), [__Average] )
3 Replies
Hi Anonymous ,
You can simply create a measure:
totalCollateralValue = SUM(tablename[COLLATERAL_VALUE])
thanks,
Pragati
Anonymous If I understand correctly, I believe you want:
Measure = SUMX( SUMMARIZE('Table',[Customer_ID],"__Average",AVERAGE([Collateral_Value])), [__Average] )Anonymous , 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])
