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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Syndicate_Admin
Administrator
Administrator

Error using "ALL" with two filters

Good morning Dear ones, please your help:

create the following action

Q_consultas = CALCULATE(COUNT(example[episodio1]),ALL(example[linea_negocio_derivacion]))
The idea is to count the number of episodes without filtering through the "linea_negocio_derivacion" column, the filter works perfectly individually and in combination with other filters, but when combining this filter with the date filter, the measure ignores the all and activates the "linea_negocio_derivacion" filter, so the objective is not met.
Data:
FernandaCortes_5-1658765592261.png

Examples of correct operation of the filter
FernandaCortes_6-1658765641865.png FernandaCortes_7-1658765667873.png

Examples of filter malfunction, the second image should not change the measurement when filtering:

FernandaCortes_8-1658765720400.pngFernandaCortes_9-1658765752939.png


Some idea of why it may occur.

1 ACCEPTED SOLUTION
v-xiaotang
Community Support
Community Support

Hi @Syndicate_Admin 

Thanks for reaching out to us.

>> but when combining this filter with the date filter, the measure ignores the all and activates the "linea_negocio_derivacion" filter, so the objective is not met.

You can try this,

vxiaotang_0-1659425549114.png

vxiaotang_1-1659425581719.png

 

Best Regards,

Community Support Team _Tang

If this post helps, please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

2 REPLIES 2
v-xiaotang
Community Support
Community Support

Hi @Syndicate_Admin 

Thanks for reaching out to us.

>> but when combining this filter with the date filter, the measure ignores the all and activates the "linea_negocio_derivacion" filter, so the objective is not met.

You can try this,

vxiaotang_0-1659425549114.png

vxiaotang_1-1659425581719.png

 

Best Regards,

Community Support Team _Tang

If this post helps, please consider Accept it as the solution to help the other members find it more quickly.

amitchandak
Super User
Super User

@Syndicate_Admin , Based on what I got. Try like

 

Q_consultas = CALCULATE(COUNT(example[episodio1]),ALL(example))

 

or

 

Q_consultas = CALCULATE(COUNT(example[episodio1]),ALL())

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

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