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. 

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.