do not show zero results in report table

[MatiasVizzari]

Buenos días, soy muy nuevo en esto, estoy tratando de hacer un informe para calcular el saldo de los pagos a proveedores y necesito ver cómo los proveedores que tienen saldo 0 no aparecen en la tabla No estoy encontrando una manera de hacerlo.

muchas gracias 

saludos 

[camargos88]

Hi @MatiasVizzari ,

Try it:

https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-show-items-no-data

[MatiasVizzari]

I wanted to share the image but I couldn't, I have a table with 3 measurements created by me and one of those measurements has many results in 0, so what I need is that if that measurement is called measure3 (to give it a name) it is = a 0 then the provider name does not appear

prov balance 1 balance 2 total
aat 10 2 12
afs 10 -10 0
asd 5 5 10
fas 5 -5 0
fast 3 -3 0
fsd 5 3 8

I mean that the code AFS, FAS and FAST do not appear.
Try the option you sent me but it doesn't work or I'm applying it more.

[camargos88 · Accepted solution]

@MatiasVizzari ,

Sorry I got it wrong.

You can edit your measures to use variables and test them, like:

Measure =

VAR _result = SUM(TABLE[COLUMN)

RETURN IF(_result = 0; BLANK(); _result)

[MatiasVizzari]

thank you very much for the answer, almost almost this, but I have balances A and B with values that adding up to 0 and it brings them to me as null but it shows them

[camargos88]

@MatiasVizzari ,

For that I think you need to test both measures and check if the required one is 0 and return blank for both.