Return all text values from single column in list, when DAX measure is >0

[User57639205]

Not sure if this would be possible either through DAX or smart narrative

I currently have a measure calculating count of customers when the customer isnt assigned a rank.

I wish to have a card displaying the names of all the customers who arent assigned a rank. Ideally seperated by space or comma.

Is this possible at all?

Thank You

[Ashish_Mathur · Accepted solution]

Hi,

This measure should work

Measure = CONCATENATEX(FILTER(VALUES(Customer[Customer name]),[Rank]=blank()),Customer[Customer name],",")

Hope this helps.

[Anonymous · Accepted solution]

Hi @User57639205 ,

Based on my testing, please try the following methods:

1.Create the sample table.

2.Create the new measure to filter the not rank.

Not Rank = IF(ISBLANK(SELECTEDVALUE('Table'[Rank])), 1, 0)

3.Create the new measure to display the not rank customer name.

CustomersNotRanked = 
CONCATENATEX(
    FILTER(
        'Table',
        [Not Rank] = 1
    ),
    'Table'[Name],
    ", "
)

4.Drag the measure into the card visual. The result is shown below.

Best Regards,

Wisdom Wu

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

[Ashish_Mathur · Accepted solution]

Hi,

This measure should work

Measure = CONCATENATEX(FILTER(VALUES(Customer[Customer name]),[Rank]=blank()),Customer[Customer name],",")

Hope this helps.

[mickey64]

For your reference.

CONCATENATE function (DAX) - DAX | Microsoft Learn

[Ritaf1983]

Hi @User57639205 

Can you please share a pbix or some dummy data that keep the raw data structure with expected results? It should help us clarify your scenario and test to coding formula.

How to Get Your Question Answered Quickly