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

     

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

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

     

     

     

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