Forum Discussion

User57639205's avatar
User57639205
Frequent Visitor
2 years ago
Solved

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

Need Help
Tips and Tricks
  • Ashish_Mathur's avatar
    Ashish_Mathur
    2 years ago

    Hi,

    This measure should work

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

    Hope this helps.

  • Anonymous's avatar
    Anonymous
    2 years ago

    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.

4 Replies

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Icon for Super User rankSuper User
    2 years ago

    Hi,

    This measure should work

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

    Hope this helps.

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    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.