Table Visual with more than one measure... how to delete empty rows when all measures are empty?

[Anonymous]

Hi guys!

I'm currently facing the issue, that a table visual is showing quite a few empty rows that I don't want to display.

The table looks like this:

Customer class	Productoption	Revenue	Order intake	Order backlog
has always values	has always values	sometimes blank	sometimes blank	sometimes blank

My task is to filter rows where revenue, order intake and oder balcklog are either empty.

These three are measures that should rather not be changed. 

my first tought was to put a filter for each measure on the table that sais Revenue is not blank , order intake is not blank and order backlog is not blank. 

Unfortunately this does not work, as the table now filters all empty revenue rows, regardles if there is a value in the other two. Therefore I'm missing some order intake rows. 

is there a way to tell the visual to filter rows if revenue, order intake AND order backlog are empty?

Thanks!

[amitchandak · Accepted solution]

@Anonymous , Ideally when all measures are blank, the row should automatically get removed unless you use +0 in a measure or use the option "Show item without data" on right click or not summarized column

If it it showing create a measure

if(isblank([Revenue]),1,0)  + if(isblank([Order intake]),1,0)  +if(isblank([Order backlog]),1,0) 

Now use a visual level filter and hide row where this new measure =2

[Anonymous]

thank you very much, it worked perfectly!

just quick add on... the filter must be "is not 3"