Measure as visual level filter

[prakash11440278]

Hi All,

I have created a measure where i want to add that measure as visual level filter but it is not returning 1 or 0. If i show the measure in card visual it is returning 0 or 1. But when i dropdown the selection it is not returning any thing. Please help.

[v-rongtiep-msft · Accepted solution]

Hi @prakash11440278 , 

I have tried your Formula. And I have not got issue.

Measure =
VAR _re =
    NOT ISEMPTY ( FILTER ( 'Table', 'Table'[rnr_emailaddress] = USERNAME () ) )
RETURN
    1 * _re

It works well. So what is your problem?

If I have misunderstood your meaning, please provide your pbix without privacy information and dsired output.

Best Regards

Community Support Team _ Polly

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

[amitchandak]

@prakash11440278 , Use count in place Not is empty an then return

if(isblank(MineisOktoShow), 0,1)

[prakash11440278]

HI @amitchandak ,

Thanks for your reply.

Below is the error i am getting.