Show only no blank values in card

[TaroGulati]

Hi everyone, 

I want to show the available values in the slicer which has some values in fact. 

I have one dimension table and one fact table. Relation is one to many. As you can see category D has no values. In the text box below I want to shows only those category which has some values. 

This is the measure that i am using: 

Filter =

UNICHAR ( 10 ) & " Category: "

&CALCULATE(CONCATENATEX ( VALUES(Dim[Category1]),Dim[Category1],", "))

do you have any suggestion how to exclude category D from the list?

Thanks

[amitchandak · Accepted solution]

@TaroGulati , using value measure

CALCULATE(CONCATENATEX ( filter(VALUES(Dim[Category1]),  not(isblank([Value])) ),  Dim[Category1],", "))

[TaroGulati]

@amitchandak perfect, it works