Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
User57639205
Frequent Visitor

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

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

2 ACCEPTED SOLUTIONS
Ashish_Mathur
Super User
Super User

Hi,

This measure should work

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

Hope this helps.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

View solution in original post

Anonymous
Not applicable

Hi @User57639205 ,

Based on my testing, please try the following methods:

1.Create the sample table.

vjiewumsft_0-1724062633249.png

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.

vjiewumsft_1-1724062684045.png

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.

View solution in original post

4 REPLIES 4
Anonymous
Not applicable

Hi @User57639205 ,

Based on my testing, please try the following methods:

1.Create the sample table.

vjiewumsft_0-1724062633249.png

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.

vjiewumsft_1-1724062684045.png

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
Super User
Super User

Hi,

This measure should work

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

Hope this helps.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/
mickey64
Super User
Super User

Ritaf1983
Super User
Super User

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  

 

 

Regards,
Rita Fainshtein | Microsoft MVP
https://www.linkedin.com/in/rita-fainshtein/
Blog : https://www.madeiradata.com/profile/ritaf/profile

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.

Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

Top Solution Authors