Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Consider the Table1 below; my objective is to calculate a column/measure that identifies whether a loan amount meets or that does not meet the following condition or does not apply:
My formula below for calculated column did not work, kindly assist.
Loan Amount | Collateral Amount | Client ID | Product ID |
200 | 300 | X1 | 2222 |
100 | 400 | X3 | 3333 |
600 | 200 | X4 | 4444 |
300 | 450 | X6 | 5555 |
100 | 0 | X7 | 6666 |
400 | 400 | X9 | 2222 |
Solved! Go to Solution.
Hi,
How about something like this
Security Measure =
VAR __Collateral = DIVIDE(SELECTEDVALUE('Table'[Collateral Amount]),SELECTEDVALUE('Table'[Loan Amount]))
VAR __ProductID = SELECTEDVALUE('Table'[Product ID ])
VAR __result = IF(__Collateral >=1.5 && __ProductID <> 2222 && __Collateral >=1.5 && __ProductID <> 4444,"Inadequate Security","Adequate Security")
RETURN __result
You need a calculated column for this, not a measure.
[Inadequately Secured] = // calc column, not a measure
IF(
NOT( T[Product ID] IN {2222, 4444} ),
IF(
T[Collateral Amount] >= 1.5 * T[Loan Amount],
"Adequate Security",
"Inadequate Security"
),
"Adequate Security"
)
If you use a measure... you won't be able to slice and dice by such values.
Hi,
How about something like this
Security Measure =
VAR __Collateral = DIVIDE(SELECTEDVALUE('Table'[Collateral Amount]),SELECTEDVALUE('Table'[Loan Amount]))
VAR __ProductID = SELECTEDVALUE('Table'[Product ID ])
VAR __result = IF(__Collateral >=1.5 && __ProductID <> 2222 && __Collateral >=1.5 && __ProductID <> 4444,"Inadequate Security","Adequate Security")
RETURN __result
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
51 | |
27 | |
24 | |
13 | |
8 |
User | Count |
---|---|
74 | |
52 | |
47 | |
16 | |
12 |