topic Filter out all blank values except one specific row in DAX Commands and Tips

Filter out all blank values except one specific row

Anonymous — Tue, 04 Oct 2022 13:06:14 GMT

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?

Re: Filter out all blank values except one specific row

tamerj1 — Tue, 04 Oct 2022 13:43:28 GMT

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

Re: Filter out all blank values except one specific row

Anonymous — Tue, 04 Oct 2022 13:52:10 GMT

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

Re: Filter out all blank values except one specific row

Anonymous — Wed, 12 Oct 2022 03:06:57 GMT

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.