Filter out all blank values except one specific row

[Anonymous]

Hello guys i have an employee payroll table

I have a visual table in dax that looks like this

Employee   hours   pay in local   pay in usd 

EmpA            100           0                 200

EmpB            125           0                 250

EmpC                           1000

EmpD              

So as you see empD is showing but i dont want him to show so i use the filter tab next to the visual and fields tab and filter out where hours is blank so empC and empD are goen now

But i want to make an exception for empC to show anyways what can i do?

[tamerj1]

@Anonymous 
Blank rows should not appear in the report by default. Please provide more context.

[Anonymous]

ok so my table has payment per hour and transportation per day whixh are fixed this is why they will show when hours id blank 

[Anonymous · Accepted solution]

Hi @Anonymous ,

If your table looks like as below, I think EmpD will be hidden by default as  tamerj1  mentioned.

You can try to turn off "Show items with no data" in columns field.

Or you can try to create a measure to filter your visual.

Measure = 
IF(SUM('Table'[hours])+SUM('Table'[pay in local])+SUM('Table'[pay in usd]) >0,1,0)

Add this measure into visual level filter and set it show items when value = 1.

Best Regards,
Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.