Forum Discussion

Anonymous's avatar
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...
DAX
if condition
Measures
  • Anonymous's avatar
    Anonymous
    6 years ago
    [India Salary] =
IF( SELECTEDVALUE( Table2[CountryName] ) = "India",
    SUM( Table1[Salary] ),
    9999
)
Fowmy's avatar
Fowmy
Icon for Super User rankSuper User
6 years ago

Anonymous 

Please explain a bit more on what exactly you need to calculate. Do you want to get the total salary of all the players if you select India or the maximum, minimum ?

________________________

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 🙂

YouTube, LinkedIn 

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    I want to calculate total salary of India.

    • Fowmy's avatar
      Fowmy
      Icon for Super User rankSuper 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 🙂

      YouTube, LinkedIn