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


     

Mariusz's avatar
Mariusz
Community Champion
6 years ago

Hi Jos13 

 

Try this, 

Measure = IF( NOT ISEMPTY( 'Table' ), "Yes", "No" )

 If not what you need, please provide the expected outcome.

 

Best Regards,
Mariusz

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

Please feel free to connect with me.
LinkedIn