Keep Specific value after filter in table

[Anonymous]

Hello everyone,

i have a payroll table that i want to filter out all 0 hour worker who dont have a fixed salary,

this is the main table with all employees

i want to filter out all employees with no work hours who dont have fixed salaries

so empA should be removed but empD should remain

but this is the resut i get

can someone he lp me i need emp D to be visable even if no hours since he has fixed salary

[Anonymous · Accepted solution]

Hi @Anonymous ,

I created a sample pbix file(see attachment) for you, please check whether that is what you want.

1. Create a measure as below 

Flag = 
VAR _selemp =
    SELECTEDVALUE ( 'Table'[Name] )
VAR _emps =
    CALCULATETABLE (
        VALUES ( 'Table'[Name] ),
        FILTER (
            'Table',
            'Table'[Total Work Time] = 0
                && 'Table'[Fixed Salary In Local] = 0
        )
    )
RETURN
    IF ( NOT ( _selemp IN _emps ), 1, 0 )

2. Create a table visual and apply a visual-level filter with the condition(Flag is 1)

Best Regards

[Anonymous]

Thank you very much