Remove rows

[Anonymous]

Hi all, 

In my report I have table, which  contain zero numbers of row.

How can I hide them. I dont wanna show "vendor #" row where "curr Yr Purchased $" and "Prior Yr Purchased $" equals $0.00

"curr Yr Purchased $" and "Prior Yr Purchased $" are measures.

help me resolve this problem. 

[mussaenda · Accepted solution]

Hide 0 = IF([curr Yr Purchased $] = 0 && [Prior Yr Purchased $]  = 0, 1, 0)

Then put this column to your filters pane and uncheck 1. This must hide the 0 that you don't want to show.

[MFelix]

Hi @Anonymous ,

On the "curr Yr Purchased $" and "Prior Yr Purchased $"  measures you can make the following syntax.

curr Yr Purchased $ = IF(SUM(Table[Column] = 0 ; BLANK() ; SUM(Table[Column])

You should change the SUM(Table[Column]) by the syntax of your measure.

Regards,

MFelix

[Anonymous]

Hi @MFelix , it's not work, any other idea?