if this column equal these values

@Hi parry2k v-alq-msft ,

First of all Im sorry I haven't explained what I'm trying to achieve here clearly. I was traying to extract few values/rows off column Division and display it in a new calculated column alone.

I do not want to display two cloumns with the same values such as v-alq-msft tried to do. I do only want to display one column Divison/Result

Filter works great on visual level and did removed the blank entry but I was hoping is to do a DAX that will remove the blank entry without doing any filtering on any visual-level.

parry2k 

Using your DAX creating a measure with MAX and use it along with Division being displayed/used will indeed remove the blank entry but both columns are displayed 

Otherwise If I only use/display your DAX measure will only display the blank entry but no Divison values.

v-alq-msft 

I liked the measure you created which will remove the blank entry if you set condition to 1 on visual-level filter. I have tried it and worked like a charm. However, SelectedValue method resulted the exact result as using MAX which shows only blank entry but no Division values. 

So both method MAX and SELECTEDVALUE only show results when division is used/displayed as well. Why is that?  

Thank you so much both for your inputs I was able however to acheive the wanted result via Filter and IsDisplat on visule-level