Compare fields' value on same issue

Marita_Burgio · July 1, 2025, 10:07am

I just realized that the original formula I suggested doesn’t correctly handle Fix version names that contain parentheses.

Can you try the following formula instead?

Instr(
  [Measures].[Issue fix versions],[Measures].[Issue First Defect Version]
)

This expression will return:

A number greater than 0 if the Fix Version contains the First Defect Version (i.e., a match is found),

And 0 if it doesn’t match.