1 ACCEPTED SOLUTION
Hi @Anonymous
Hope attached file satisfies your requirement
Insurance =
SUMX (
FILTER (
'Table',
'Table'[Nationality ] = "Non-Italy"
),
IF (
'Table'[Years] < 3,
'Table'[Salary] / 24,
'Table'[Salary] / 12
)
)
Hi @Anonymous
Hope attached file satisfies your requirement
Insurance =
SUMX (
FILTER (
'Table',
'Table'[Nationality ] = "Non-Italy"
),
IF (
'Table'[Years] < 3,
'Table'[Salary] / 24,
'Table'[Salary] / 12
)
)
hello @Anonymous ,
please try:
Measure =
VAR selected = SELECTEDVALUE(Table1[Nationality ])
return
IF( selected <> "Italy" && MAX(Table1[Years]) < 3,SUM(Table1[Salary])/24,IF(selected <> "Italy",SUM(Table1[Salary])/12,0))
Helpful resources
Fabric Data Days
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
Power BI Monthly Update - October 2025
Check out the October 2025 Power BI update to learn about new features.
FabCon Atlanta 2026
Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
