Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

in measures

fgf
Help
  • tamerj1's avatar
    tamerj1
    3 years ago

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

     

tamerj1's avatar
tamerj1
Icon for Community Champion rankCommunity Champion
3 years ago

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