Issue with IF function not returning proper values

Hello.

We are working with a calculated column that is to return the Course Title value from Table 1 when the key values in a column matches to a value in Table 2. When the Course Title is a blank value, we want it to return “No Description”.

We have the following DAX expression, but it is not properly working. It’s giving the “No Description” value and providing “Blanks” where there should be the Course Title values. See below.

DB Equivalency Course Title = IF(‘Equivalencies’[DB Equivalency] = “Match”,(LOOKUPVALUE(‘DB Courses Summer 2020’[Course Title],‘DB Courses Summer 2020’[Subject-Catalog],‘Equivalencies’[Residential Subj-Cat Key])), “No Description”)

Please assist.

without seeing the data pretty much impossible to troubleshoot. But this type of thing should be done in Power Query if possible (in my view at least)

@jmwdba,

A sample .pbix will allow for a more correct answer to your question but try this format and see if it helps in some way:

Training Compliance =
VAR lookup =
    LOOKUPVALUE (
        'DB Courses Summer 2020'[Course Title],
        'DB Courses Summer 2020'[Subject-Catalog], 'Equivalencies'[Residential Subj-Cat Key]
    )
VAR dbEquivalency = SELECTEDVALUE ( Equivalencies[DB Equivalency] )

RETURN
    IF ( dbEquivalency = "Match", lookup, "No Description" )
1 Like

Thanks for posting your question @jmwdba. To receive a resolution in a timely manner please make sure that you provide all the necessary details on this thread.

Here is a potential list of additional information to include in this thread; demo pbix file, images of the entire scenario you are dealing with, screenshot of the data model, details of how you want to visualize a result, and any other supporting links and details.

Including all of the above will likely enable a quick solution to your question.

Hi @jmwdba, we’ve noticed that no response has been received from you since the 2nd of April. We just want to check if you still need further help with this post? In case there won’t be any activity on it in the next few days, we’ll be tagging this post as Solved. If you have a follow question or concern related to this topic, please remove the Solution tag first by clicking the three dots beside Reply and then untick the checkbox. Thanks!