Forum Discussion

prakash11440278's avatar
prakash11440278
Post Prodigy
4 years ago
Solved

Measure as visual level filter

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 dropd...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    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's avatar
amitchandak
Super User
4 years ago

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

 

if(isblank(MineisOktoShow), 0,1)

  • prakash11440278's avatar
    prakash11440278
    Post Prodigy
    4 years ago

    HI amitchandak ,

    Thanks for your reply.

    Below is the error i am getting.