Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
94veiga
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:

 

94veiga_0-1624361226769.png

 

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!!

 

1 REPLY 1
v-rzhou-msft
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

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.