DataScience Show

DataScience Show

Share this post

DataScience Show
DataScience Show
Mastering Power BI Filters with ALL and ALLCROSSFILTERED

Mastering Power BI Filters with ALL and ALLCROSSFILTERED

Mirko Peters - M365 Specialist's avatar
Mirko Peters - M365 Specialist
Jun 03, 2025
∙ Paid

Share this post

DataScience Show
DataScience Show
Mastering Power BI Filters with ALL and ALLCROSSFILTERED
Share

Filters play a crucial role in Power BI, and understanding how to manage them effectively can transform your data analysis. The ALL function clears all filters from the expanded table you specify, ignoring any relationships. On the other hand, ALLCROSSFILTERED respects cross-filtering relationships, making it invaluable in scenarios involving many-to-ma…

Keep reading with a 7-day free trial

Subscribe to DataScience Show to keep reading this post and get 7 days of free access to the full post archives.

Already a paid subscriber? Sign in
© 2025 Mirko Peters
Privacy ∙ Terms ∙ Collection notice
Start writingGet the app
Substack is the home for great culture

Share