Hide Columns with no data

[Analitika]

I have measure

Measure=

VAR val1 = IF (

ISINSCOPE(Table1[Names]),

BLANK(),

                                FORMAT ( [MesureDivide], "0.00%" )

)

VAR val2 = [COGS]

RETURN

SWITCH( SELECTEDVALUE(Table3[Surnames])

,"Sales",   val1
,"COGS",   val2

,BLANK()
)

But it return blanks or empty values which not hiding and not possible to filter

How to hide thoose rows and columns? Problems seam with FORMAT functions, as without it everything work fine, but not showing %

[Anonymous]

Hello @Analitika ,
Instead of format try like this 

[MesureDivide] &"0.00%"

[Analitika]

@Anonymous

Not work as showing zeroes value

[Anonymous]

Can you just check this [MesureDivide] and instead of format return this [MesureDivide] and check are you getting the expected value?

[Analitika]

Then everything works instead of formating to %