topic Keep Specific value after filter in table in DAX Commands and Tips

Keep Specific value after filter in table

Anonymous — Tue, 11 Oct 2022 12:57:38 GMT

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

Re: Keep Specific value after filter in table

Anonymous — Wed, 12 Oct 2022 07:17:18 GMT

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

Re: Keep Specific value after filter in table

Anonymous — Wed, 12 Oct 2022 10:22:42 GMT

Thank you very much