If description is blank, use other description.

[Timothyg]

Hi all

I need assistance with a report on Power BI report builder.

I have a code and description but if that description is blank, it must use a different fields description.

I have the below code that works on the code & description but if the description is blank, it must use the function description instead with the code. Some of the codes have descriptions but for the codes with no description, it must pull from the function description.

=IIF(IsNOTHING(Fields!Code.Value), " ", IIF(Parameters!SHOWCODE.Value = True, Fields!Code.Value + " - " + Fields!Description.Value, Fields!Description.Value))

I hope someone will be able to assist me in the right direction.

[Bibiano_Geraldo · Accepted solution]

HI @Timothyg ,

Try to modify your expression using this, and let me know if worked:

=IIF(IsNothing(Fields!Code.Value), " ", 
    IIF(Parameters!SHOWCODE.Value = True, 
        Fields!Code.Value + " - " + 
        IIF(IsNothing(Fields!Description.Value) OR Fields!Description.Value = "", Fields!FunctionDescription.Value, Fields!Description.Value), 
        IIF(IsNothing(Fields!Description.Value) OR Fields!Description.Value = "", Fields!FunctionDescription.Value, Fields!Description.Value)
    )
)

If this help you, please consider to mark it as solution and give a kudo.

Thank you

[rajendraongole1]

Hi @Timothyg - you can adjust your expression to add this fallback logic.

=IIF(IsNothing(Fields!Code.Value),
" ",
IIF(Parameters!SHOWCODE.Value = True,
Fields!Code.Value & " - " &
IIF(IsNothing(Fields!Description.Value) OR Trim(Fields!Description.Value) = "", Fields!FunctionDescription.Value, Fields!Description.Value),
IIF(IsNothing(Fields!Description.Value) OR Trim(Fields!Description.Value) = "", Fields!FunctionDescription.Value, Fields!Description.Value)
)
)

Function Description when Description is blank, displaying the Code only when SHOWCODE is set to True

Hope this helps.