Forum Discussion

mtdimaria's avatar
mtdimaria
New Member
2 years ago

Trouble Comparing Columns in Different Tables

Hello,

 

I'm having trouble comparing columns that are in two different tables. In the image below, I want to compare Expected Base Loss and Base Loss. If the two numbers match, then I want Base Loss Accuracy to read Yes, if they don't then it should read No.

 

This is what I currently have in the function

Base Loss Accuracy =
var _Table1 = SELECTEDVALUE('Service'[Base Loss])
var _Table2 = SELECTEDVALUE('Valu-Rite'[Expected Base Loss])
return
IF(_Table1 = _Table2, "Yes", "No")



 

Need Help

1 Reply

  • vicky_'s avatar
    vicky_
    Super User
    2 years ago

    Please check that your numbers aren't being summarised (e.g. SUM, AVERGE, etc). 
    I suspect that your SELECTEDVALUE() is returning blanks because there might be more than 1 value for 'Service'[Base Loss] and 'Valu-Rite'[Expected Base Loss] per row.