Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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
Solved! Go to Solution.
Hi,
This measure should work
Measure = CONCATENATEX(FILTER(VALUES(Customer[Customer name]),[Rank]=blank()),Customer[Customer name],",")
Hope this helps.
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.
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.
Hi,
This measure should work
Measure = CONCATENATEX(FILTER(VALUES(Customer[Customer name]),[Rank]=blank()),Customer[Customer name],",")
Hope this helps.
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
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
97 | |
96 | |
58 | |
45 | |
42 |