Forum Discussion

RAdams's avatar
RAdams
Icon for Helper III rankHelper III
8 years ago
Solved

HASONEFILTER to show Text

Hello everyone! I have a question regarding showing columns in a table when a slicer is selected.    I have this code, which works fine when the slicer is selected.  It's showing the data from one ...
Need Help
  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    8 years ago

    Hi RAdams

     

    Concatenatex takes atleast two arguments ...first argument a table or an expression that returns a table. The second argument is a column that contains the values you want to concatenate, or an expression that returns a value.

    Try this

     

    Customer =
IF (
    HASONEFILTER ( 'Sales Data'[CustomerName] ),
    CONCATENATEX ( VALUES ( AR[customer_name] ), AR[customer_name] ),
    BLANK ()
)

     

Zubair_Muhammad's avatar
Zubair_Muhammad
Icon for Community Champion rankCommunity Champion
8 years ago

Hi RAdams

 

Concatenatex takes atleast two arguments ...first argument a table or an expression that returns a table. The second argument is a column that contains the values you want to concatenate, or an expression that returns a value.

Try this

 

Customer =
IF (
    HASONEFILTER ( 'Sales Data'[CustomerName] ),
    CONCATENATEX ( VALUES ( AR[customer_name] ), AR[customer_name] ),
    BLANK ()
)

 

  • RAdams's avatar
    RAdams
    Icon for Helper III rankHelper III
    8 years ago

    NICE!!!

     

    Everyone in the office is looking at me as I squeal like a little girl! 

     

    Thanks Zubair_Muhammad!

     

    R