How to Add Value to result

[pokdbz]

I have the DAX below that works correctly.
I want to manually add a value to 'Store'[BaseStoreNumber] = 96 after the result of the lookup.  

Is it possible to do this?

Original result

10, 15, 20

Result needed

10, 15, 20, 96

IF (
'Store'[Class Desc] = "NON-BANNER",
(
'Store'[BaseStoreNumber]
= LOOKUPVALUE (
Security[BaseStoreNumber],
Security[UserPrincipalName], USERPRINCIPALNAME(),
Security[BaseStoreNumber], Store[BaseStoreNumber]
)
)
)

[Anonymous]

Hi @pokdbz 

Maybe you can use the UNION() function:

UNION function (DAX) - DAX | Microsoft Learn

Please try this:

VAR _AA =
    IF (
        'Store'[Class Desc] = "NON-BANNER",
        (
            'Store'[BaseStoreNumber]
                = LOOKUPVALUE (
                    Security[BaseStoreNumber],
                    Security[UserPrincipalName], USERPRINCIPALNAME (),
                    Security[BaseStoreNumber], Store[BaseStoreNumber]
                )
        )
    )
RETURN
    UNION ( _AA, { 96 } )

Best Regards

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

[pokdbz]

Any other suggestions?

[pokdbz]

It's saying the UNION function expects a table expression for argument "", but a string or numeric expression was used.  Its highlighting the _AA