Showing results for 
Search instead for 
Did you mean: 
Helper II
Helper II

No funciona el filtro al meter una medida en una tabla

Hola a todos!!


Estoy intendando hacer una tabla en la que aparecen ciertas empresas, lo que les han facturado y lo que tienen pendiente de cobro. Estoy intentando hacer una medida para saber en qué estado están estas empresas (todo facturado y cobrado, facturado pero pendiente de cobro, sin facturar). Para ello he creado la siguiente medida:




La medida funciona pero, cuando filtro la tabla, me aparecen todos los valores y no solo los filtrados, es decir, el filtro pierde su efecto.


Muchas gracias!!


Community Support
Community Support

Hi @94veiga 

Is your issue that when you filter your table the measure show wrong result? Your switch measure is based on [Total facturado] and [Total pendiente cobro] measures. So please check whether there is something wrong in these two measures. And you can share a sample without sensitive privacy data with me by your Onedrive for Buesiness. And you can show me a screenshot of your issue and show me the result you want. This will make it easier for me to understand your requirement.


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. 


Helpful resources

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.