Forum Discussion

Anonymous

Not applicable

6 years ago

Solved

create measure using two tables and if condition

Hi, I have two tables similar like below : Table1 Person CountryID Salary Sachin Ind 100 Dhoni Ind 200 Messi Arg 300 Nadal Sp 400 Table2 CountryNa...

Anonymous

6 years ago

[India Salary] =
IF( SELECTEDVALUE( Table2[CountryName] ) = "India",
    SUM( Table1[Salary] ),
    9999
)

Super User

6 years ago

Anonymous ,

Measure=IF(MAX(Table2[CountryName])="India",Sum(Table1[Salary]),9999)