Forum Discussion

sokatenaj's avatar
sokatenaj
Advocate II
8 years ago
Solved

Missing Values

Hi Folks,   I have the following data:                    I have the following measure that represents "Annual Salary (USD)":              Annual Salary (USD) = SUMX(Active, Active...
Need Help
  • sokatenaj's avatar
    sokatenaj
    8 years ago

    I ended up figuring out what the issue was. I had a table with a relationship that was causing missing values because of the bidirectional nature of the relationship and the type. I removed it and just did it as a VLOOKUP and all is well :) 

     

    Thanks so much. 

parry2k's avatar
parry2k
Super User
8 years ago

did you added this new calculation as a measure or column.

 

Can you try following, add as a new column:

 

Annual Salary (USD) Test = Active[Annual Salary (Local Currency)]*Related('FX Rates'[Exchange Rate])

 

 

  • sokatenaj's avatar
    sokatenaj
    Advocate II
    8 years ago

    It's a measure used as a field in a table. 

    • parry2k's avatar
      parry2k
      Super User
      8 years ago

      Did you tried adding a column as suggested in my previous reply?

    • v-huizhn-msft's avatar
      v-huizhn-msft
      Microsoft Employee
      8 years ago

      Hi sokatenaj,

      Please create a calculated column using the formula below in Table 'Active', and check if the value is blank for 5th and 6th rows.

       

      Exchange Rate=Related('FX Rates'[Exchange Rate])


      Please respond to me if you have any other issue.

      Best Regards,
      Angelia

      • sokatenaj's avatar
        sokatenaj
        Advocate II
        8 years ago

        I ended up figuring out what the issue was. I had a table with a relationship that was causing missing values because of the bidirectional nature of the relationship and the type. I removed it and just did it as a VLOOKUP and all is well :) 

         

        Thanks so much.