Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Keep Specific value after filter in table

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...
  • Anonymous's avatar
    Anonymous
    3 years ago

    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's avatar
Anonymous
Not applicable
3 years ago

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's avatar
Anonymous
Not applicable
3 years ago

Thank you very much