Creating a Measure to Display Values Despite Missing Relationships

[PKPK90]

I want to create a measure that displays values for the remaining two columns even if there is no relationship with the 'Purchase_Orders_Releases (2)' table. Currently, when there is no relationship to 'Purchase_Orders_Releases (2)', the result of the measure is blank.

The current measure is:

PONO-LINE-REL =
CONCATENATEX(
Purchase_Orders,
Purchase_Orders[PONO] & "-" &
CONCATENATEX(
Purchase_Orders_Detail,
Purchase_Orders_Detail[SEQ],
"-"
) & "-" &
IF(
ISBLANK(MAX('Purchase_Orders_Releases (2)'[SEQ])),
BLANK(),
CONCATENATEX(
'Purchase_Orders_Releases (2)',
'Purchase_Orders_Releases (2)'[SEQ],
"-"
)
),
"-"
)

[Anonymous]

Hi @PKPK90 ,

I can't be of much help. Perhaps you can provide me with your pbix file? and the desired results.

Please delete sensitive data and do not log into your account in Power BI Desktop when uploading pbix files.

All this is to better solve your problem.

I would appreciate if you could get back to me as soon as possible.

Best Regards,

Clara Gong

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