November 6, 2026 at 8:02 AM
The best way to use ALL, ALLSELECTED, ALLEXCEPT functions in Power BI #data #dataanalytics #powerbi #allfunction #percentoftotal
October 31, 2026 at 8:01 AM
The best way to use ALL, ALLSELECTED, ALLEXCEPT functions in Power BI #data #dataanalytics #powerbi #allfunction #percentoftotal
The best way to use ALL, ALLSELECTED, ALLEXCEPT functions in Power BI #data #dataanalytics #powerbi #allfunction #percentoftotal
October 31, 2026 at 8:01 AM
The best way to use ALL, ALLSELECTED, ALLEXCEPT functions in Power BI #data #dataanalytics #powerbi #allfunction #percentoftotal
It highlighted high and low values in different colors.
The challenge was writing the DAX measures to make the chart work dynamically in Power Pivot, especially w/ filters applied. 🔑The key? Use iterator functions like MINX and MAXX paired w/ ALL or ALLSELECTED to control what context is evaluated.
The challenge was writing the DAX measures to make the chart work dynamically in Power Pivot, especially w/ filters applied. 🔑The key? Use iterator functions like MINX and MAXX paired w/ ALL or ALLSELECTED to control what context is evaluated.
April 7, 2026 at 7:17 PM
It highlighted high and low values in different colors.
The challenge was writing the DAX measures to make the chart work dynamically in Power Pivot, especially w/ filters applied. 🔑The key? Use iterator functions like MINX and MAXX paired w/ ALL or ALLSELECTED to control what context is evaluated.
The challenge was writing the DAX measures to make the chart work dynamically in Power Pivot, especially w/ filters applied. 🔑The key? Use iterator functions like MINX and MAXX paired w/ ALL or ALLSELECTED to control what context is evaluated.
A student asked me a fantastic question: how do you replicate a dynamic chart highlight in #Excel - one that visually flags the minimum, maximum, and neutral data points - when working inside #PowerPivot with #DAX measures? 📊
They had built a clever Excel chart using 3 overlapping series at 100%...🧵
They had built a clever Excel chart using 3 overlapping series at 100%...🧵
April 7, 2026 at 7:17 PM
A student asked me a fantastic question: how do you replicate a dynamic chart highlight in #Excel - one that visually flags the minimum, maximum, and neutral data points - when working inside #PowerPivot with #DAX measures? 📊
They had built a clever Excel chart using 3 overlapping series at 100%...🧵
They had built a clever Excel chart using 3 overlapping series at 100%...🧵
Feed: "SQLBI"
By: Alberto Ferrari on Monday, June 1, 2026
By: Alberto Ferrari on Monday, June 1, 2026
ALL vs ALLSELECTED vs ALLEXCEPT vs REMOVEFILTERS
DAX offers many functions to remove filters from the filter context. In this article, we analyze the differences among the most commonly-used functions. Com
www.sqlbi.com
June 3, 2026 at 6:34 AM
Feed: "SQLBI"
By: Alberto Ferrari on Monday, June 1, 2026
By: Alberto Ferrari on Monday, June 1, 2026
Feed: "SQLBI"
By: Alberto Ferrari on Monday, July 14, 2025
By: Alberto Ferrari on Monday, July 14, 2025
ALLSELECTED best practices
ALLSELECTED is a powerful, yet dangerous function. This article describes the best practices to follow to avoid falling into the pitfalls involved with ALLS
www.sqlbi.com
July 15, 2025 at 2:02 PM
Feed: "SQLBI"
By: Alberto Ferrari on Monday, July 14, 2025
By: Alberto Ferrari on Monday, July 14, 2025
Feed: "SQLBI"
By: Alberto Ferrari on Tuesday, July 15, 2025
By: Alberto Ferrari on Tuesday, July 15, 2025
ALLSELECTED best practices
Learn the best practices for ALLSELECTED to avoid falling into the pitfalls of this powerful, yet dangerous function!
www.sqlbi.com
July 15, 2025 at 2:02 PM
Feed: "SQLBI"
By: Alberto Ferrari on Tuesday, July 15, 2025
By: Alberto Ferrari on Tuesday, July 15, 2025
Make your chart dynamic and always highlight the true min/max of what is visible by using iterator functions like MINX and MAXX plus ALL or ALLSELECTED to carefully control what context is being evaluated.
🧭Takeaway: The best charts do not just show data - they tell the story of where you stand.
🧭Takeaway: The best charts do not just show data - they tell the story of where you stand.
March 23, 2026 at 4:39 PM
Make your chart dynamic and always highlight the true min/max of what is visible by using iterator functions like MINX and MAXX plus ALL or ALLSELECTED to carefully control what context is being evaluated.
🧭Takeaway: The best charts do not just show data - they tell the story of where you stand.
🧭Takeaway: The best charts do not just show data - they tell the story of where you stand.
In our last Ask Ken Anything (AKA) session, one of our students asked a fantastic question: how do you replicate a dynamic chart highlight in #Excel - one that visually flags the minimum, maximum, and neutral data points - when working inside #PowerPivot with #DAX measures? 📊
🧵
🧵
March 23, 2026 at 4:39 PM
In our last Ask Ken Anything (AKA) session, one of our students asked a fantastic question: how do you replicate a dynamic chart highlight in #Excel - one that visually flags the minimum, maximum, and neutral data points - when working inside #PowerPivot with #DAX measures? 📊
🧵
🧵
ALL vs ALLSELECTED vs ALLEXCEPT vs REMOVEFILTERS by Alberto Ferrari #PowerBI www.sqlbi.com/articles/all...
ALL vs ALLSELECTED vs ALLEXCEPT vs REMOVEFILTERS - SQLBI
DAX offers many functions to remove filters from the filter context. In this article, we analyze the differences among the most commonly-used functions. Com
www.sqlbi.com
June 8, 2026 at 3:20 PM
ALL vs ALLSELECTED vs ALLEXCEPT vs REMOVEFILTERS by Alberto Ferrari #PowerBI www.sqlbi.com/articles/all...
ALLSELECTED best practices by Alberto Ferrari #PowerBI www.sqlbi.com/articles/all...
ALLSELECTED best practices - SQLBI
ALLSELECTED is a powerful, yet dangerous function. This article describes the best practices to follow to avoid falling into the pitfalls involved with ALLS
www.sqlbi.com
July 22, 2025 at 3:20 PM
ALLSELECTED best practices by Alberto Ferrari #PowerBI www.sqlbi.com/articles/all...
Interesting #PowerBI error message in this calc item @jaypowerbi.bsky.social , given I'm not using ALLSELECTED here.
(I know why I'm getting it...because my function expects a Table that it uses to remove row context when doing a calc, and I was trying to say "Remove row context in any form")
(I know why I'm getting it...because my function expects a Table that it uses to remove row context when doing a calc, and I was trying to say "Remove row context in any form")
November 19, 2025 at 8:20 PM
Interesting #PowerBI error message in this calc item @jaypowerbi.bsky.social , given I'm not using ALLSELECTED here.
(I know why I'm getting it...because my function expects a Table that it uses to remove row context when doing a calc, and I was trying to say "Remove row context in any form")
(I know why I'm getting it...because my function expects a Table that it uses to remove row context when doing a calc, and I was trying to say "Remove row context in any form")
^ I realise this is probably never gonna happen in DAX because "Rows" and "Columns" are not generic across all visuals. Maybe instead the option to have "Ignore ALLSELECTED()" setting at the visual field level in the format pane.
But imagine troubleshooting that, if you weren't aware of it.
But imagine troubleshooting that, if you weren't aware of it.
September 16, 2025 at 9:47 PM
^ I realise this is probably never gonna happen in DAX because "Rows" and "Columns" are not generic across all visuals. Maybe instead the option to have "Ignore ALLSELECTED()" setting at the visual field level in the format pane.
But imagine troubleshooting that, if you weren't aware of it.
But imagine troubleshooting that, if you weren't aware of it.
Like, I wish Alberto used Lego as a visual aid in this video:
www.youtube.com/watch?v=EwQC...
www.youtube.com/watch?v=EwQC...
ALLSELECTED best practices
YouTube video by SQLBI
www.youtube.com
August 28, 2025 at 12:30 AM
Like, I wish Alberto used Lego as a visual aid in this video:
www.youtube.com/watch?v=EwQC...
www.youtube.com/watch?v=EwQC...
ALL, ALLSELECTED, ALLEXCEPT, and REMOVEFILTERS: There are several DAX functions to remove filters from the filter context. This article + video clarifies what to use depending on the requirements.
#dax #powerbi
https://www.sqlbi.com/articles/all-vs-allselected-vs-allexcept-vs-removefilters/
#dax #powerbi
https://www.sqlbi.com/articles/all-vs-allselected-vs-allexcept-vs-removefilters/
June 2, 2026 at 10:02 AM
ALL, ALLSELECTED, ALLEXCEPT, and REMOVEFILTERS: There are several DAX functions to remove filters from the filter context. This article + video clarifies what to use depending on the requirements.
#dax #powerbi
https://www.sqlbi.com/articles/all-vs-allselected-vs-allexcept-vs-removefilters/
#dax #powerbi
https://www.sqlbi.com/articles/all-vs-allselected-vs-allexcept-vs-removefilters/
This article (with video) outlines best practices for utilizing ALLSELECTED in your DAX measures to prevent unpredictable results!
#dax #powerbi
https://www.sqlbi.com/articles/allselected-best-practices/
#dax #powerbi
https://www.sqlbi.com/articles/allselected-best-practices/
July 15, 2025 at 10:02 AM
This article (with video) outlines best practices for utilizing ALLSELECTED in your DAX measures to prevent unpredictable results!
#dax #powerbi
https://www.sqlbi.com/articles/allselected-best-practices/
#dax #powerbi
https://www.sqlbi.com/articles/allselected-best-practices/
Power BI DAX Functions: Basics to Real-World Cases: Explore Power BI DAX functions with practical examples. Learn basic functions like CALCULATE, ALL, ALLSELECTED, ALLEXCEPT, DIVIDE, IF, and DATEADD, and see how to apply them in… @PowerBI #PowerBI #DAX #DataAnalytics #BusinessIntelligence #Microsoft
Power BI DAX Functions: Basics to Real-World Cases
Explore Power BI DAX functions with practical examples. Learn basic functions like CALCULATE, ALL, ALLSELECTED, ALLEXCEPT, DIVIDE, IF, and DATEADD, and see how to apply them in real-world scenarios.
dlvr.it
September 27, 2025 at 11:38 AM
Power BI DAX Functions: Basics to Real-World Cases: Explore Power BI DAX functions with practical examples. Learn basic functions like CALCULATE, ALL, ALLSELECTED, ALLEXCEPT, DIVIDE, IF, and DATEADD, and see how to apply them in… @PowerBI #PowerBI #DAX #DataAnalytics #BusinessIntelligence #Microsoft
Let's start here. When Elmo says that no one has ever done this before, that is objectively false. The BrainGate project (still ongoing) has been implanting chips into paralyzed patient's brains since the study began in 2004.
braingate.org/publications-t…
braingate.org/publications-t…
Publications Timeline - BrainGate
BrainGate Publication Timelines AllSelected Achievements Neuroscience Neural EngineeringCommunicationMovement RestorationSpeech RestorationNeurotherapeutics
www.braingate.org
March 30, 2025 at 5:05 PM
Let's start here. When Elmo says that no one has ever done this before, that is objectively false. The BrainGate project (still ongoing) has been implanting chips into paralyzed patient's brains since the study began in 2004.
braingate.org/publications-t…
braingate.org/publications-t…