Forum Discussion

pokdbz's avatar
pokdbz
Icon for Helper II rankHelper II
2 years ago

How to Add Value to result

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, ...
Anonymous's avatar
Anonymous
Not applicable
2 years ago

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's avatar
pokdbz
Icon for Helper II rankHelper II
2 years ago

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