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


     

Jos13's avatar
Jos13
Helper III
6 years ago

Hi,

The above mentioned measures return a value even if the employee id is not selected. This measure should return a value only when the employee id is selected otherwise it can return blank.

 

Thanks,

Jos

Mariusz's avatar
Mariusz
Community Champion
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