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, 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]
)
)
)

3 Replies

  • 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