Forum Discussion
Need help with an If statement
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.
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.
