cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
MMPagola
Helper I
Helper I

NO MOSTRAR REGISTROS CON VALORES EN CERO

Hola, he ledio varios posteos pero no encuentro solución a mi problema. Tengo PEDIDOS y algunos están facturados en su totalidad y otros no. Necesito solo ver los que no están facturados. He calculado la fórmula de ls siguiente manera:

CANTIDAD PENDIENTE DE FACTURAR = CALCULATE(SUM((GVA03[PEN_FAC_RE])), GVA03[PEN_FAC_RE] >0)

Al insertar el campo en la tabla, me muestra los registros con el campo vacío. Necesito que no los muestre durectamente. Adjunto pantalla y agredezco toda ayuda.

 

MMPagola_0-1627744279276.png

 

1 ACCEPTED SOLUTION

You can hide the filter selection the option shows below

Portrek_0-1627754961322.png

 

View solution in original post

4 REPLIES 4
Portrek
Resolver III
Resolver III

Hi

Choose the filter and put "is more than" 0, like the image below

Portrek_0-1627750727261.png

 

Best regards.

Thank you but I dont want to apply a filter that the user can see. I need another option.

You can hide the filter selection the option shows below

Portrek_0-1627754961322.png

 

View solution in original post

I didnt know that. I'll try, thank you very much

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

November Power BI Update 768x460.png

Check it Out!

Click here to read more about the November 2021 Updates!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.