Need help with an If statement

[Rnaval]

I have a matrix, and for one of the columns I would like to use either of two fields, whichever is not blank. Is there a way to do that?

[v-tsaipranay · Accepted solution]

Hi @Rnaval ,

Thanks for reaching out to the Microsoft Fabric Community.

Since you're working with a matrix visual and want to show the value from either Field1 or Field2 (whichever is not blank), the approach shared by @pankajnamekar25  is correct and best suited for this scenario.

You can use the following measure:

Display Value =

COALESCE(

    SELECTEDVALUE(Table[Field1]),

    SELECTEDVALUE(Table[Field2])

)

To use this:

• Go to Modeling > New Measure, paste the formula, and add the measure to your matrix.

This will display Field1 when available, and fall back to Field2 when it’s blank exactly as intended.

If this post helps, then please give us Kudos and consider Accept it as a solution to help the other members find it more quickly.

Thankyou.

[Rnaval]

Ok I got it working. Thanks. However, it seems I cannot use this "Display Measure" in a card, is there any way around this? Do I need to create a new custom column instead?

[Rnaval]

Actually, I added a column and then all works fine now. Thanks...

[bhanu_gautam]

@Rnaval 

You can create a new column with the following DAX formula:

NewColumn = IF(NOT(ISBLANK([Field1])), [Field1], [Field2])

[Rnaval]

I get an error message regarding the "IF" expression

[pankajnamekar25]

Hello @Rnaval 

use below code dax

Display Value =
COALESCE(
SELECTEDVALUE(Table[Field1]),
SELECTEDVALUE(Table[Field2])
)

Thanks,
 Pankaj Namekar | LinkedIn

If this solution helps, please accept it and give a kudos (Like), it would be greatly appreciated.

[Rnaval]

Where would I enter this code?