cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
RAdams Regular Visitor
Regular Visitor

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 customer as the Sales Data table has one row for each Customer and their respective sales data. I had to use Sum to get the data to show up even though there is only one row. 

 

 

 Balance = IF(
HASONEFILTER('Sales Data'[CustomerName]),
SUM(AR[balance_due]),
BLANK()
)

 

Now, I'm trying to show the Customer Name in the same table mentioned above. Here's the code I've written after a few iterations of trying to get it to work: 

 

 

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

 

 

But nothing seems to be working. I just want the Customer Name, Balance Due and a few other values to show up when one item is selected in the Slicer. 

 

Any help would be great! 

 

Thanks!

R

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Super User
Super User

Re: HASONEFILTER to show Text

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 ()
)

 

2 REPLIES 2
Highlighted
Super User
Super User

Re: HASONEFILTER to show Text

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 Regular Visitor
Regular Visitor

Re: HASONEFILTER to show Text

NICE!!!

 

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

 

Thanks @Zubair_Muhammad!

 

R

Helpful resources

Announcements
Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Power BI Helps Homeless and Trouble Youth

Power BI Helps Homeless and Trouble Youth

We spoke with Power BI Super User, Greg Deckler, about his charity work

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Top Kudoed Authors
Users Online
Currently online: 6 members 1,940 guests
Please welcome our newest community members: