Forum Discussion

Jos13's avatar
Jos13
Helper III
6 years ago
Solved

Filter not working

Hi Team, I just have to find whether a particular employee's data is there in the table by filtering month and task. I have created a measure as follows. Measure = IF(SELECTEDVALUE('Table'[EmpId])...
Data Protection
  • Mariusz's avatar
    Mariusz
    6 years ago

    Hi Jos13 

     

    Sure, try this.

    Measure = 
IF( 
    ISFILTERED( 'Table'[Empid] ),
    IF( NOT ISEMPTY( 'Table' ), "Yes", "No" )
)

     

    Best Regards,
    Mariusz

    If this post helps, then please consider Accepting it as the solution.

    Please feel free to connect with me.
    LinkedIn


     

amitchandak's avatar
amitchandak
Super User
6 years ago

Jos13 , try like

calculate(if(Max('Table'[EmpId]) =SELECTEDVALUE('Table'[EmpId]),"Yes","No"),values('Table'[EmpId]))