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
)

Anonymous

Not applicable

6 years ago

I want to calculate total salary of India.

Super User

6 years ago

Anonymous

Try:

Measure = CALCULATE( SUM(Table1.Salary),Table2.CountryName="India")

________________________

Did I answer your question? Mark this post as a solution, this will help others!.

Click on the Thumbs-Up icon on the right if you like this reply 🙂