Display column

[marbi]

Kindly help. I want to display the queue names having no blank job ids. What DAX should I use.

[Anonymous]

HI @marbi,

You can add a filter on the page to check if the job id not equal to blank ,then the slicer should only display the names that not has blank job id.

For handle different type of blanks, you can refer to the following blog:

How to handle BLANK in DAX measures - SQLBI

Regards,

Xiaoxin Sheng

[Ritaf1983 · Accepted solution]

Hi @marbi 
If I understood you correctly, you can just filter your slicer by not blanks IDs, without Dax.
Just put the id column on the filter pane

If it is something else 

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-...
Please show the expected outcome based on the sample data you provided.

https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523

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