Forum Discussion
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 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
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
2 Replies
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