Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
Anonymous
Not applicable

in measures

fgf

1 ACCEPTED SOLUTION
tamerj1
Super User
Super User

Hi @Anonymous 
Hope attached file satisfies your requirement

1.png

Insurance = 
SUMX ( 
    FILTER ( 
        'Table', 
        'Table'[Nationality ] = "Non-Italy"
    ),
    IF (
        'Table'[Years] < 3, 
        'Table'[Salary] / 24,
        'Table'[Salary] / 12
    )
)

 

View solution in original post

2 REPLIES 2
tamerj1
Super User
Super User

Hi @Anonymous 
Hope attached file satisfies your requirement

1.png

Insurance = 
SUMX ( 
    FILTER ( 
        'Table', 
        'Table'[Nationality ] = "Non-Italy"
    ),
    IF (
        'Table'[Years] < 3, 
        'Table'[Salary] / 24,
        'Table'[Salary] / 12
    )
)

 

Anonymous
Not applicable

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))

 

 

Screenshot 2022-11-08 181123.png

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.

Top Kudoed Authors