Posts tagged #Disconnected Slicers

P3: Disconnected Slicers With DAX Variables And SELECTEDVALUES

Article by: Reid Havens

Today’s topic covers how to create a Disconnected Slicer using DAX Variables and SELECTEDVALUES. We’ve easily written a few dozen articles over the years on ways to use disconnected slicers, and here’s another one!

The great thing about DAX is that as it EVOLVES, writing measures and utilizing certain features becomes easier. That’s the goal of this video, it’s not re-inventing the wheel, just refining it. I’ve included below the original DAX Formula I used in the walkthrough. Otherwise, enjoy the video!

P3: DAX “Reanimator” Series, Episode 1: Dynamic TopN Reports via Slicers

Article by: Reid Havens

Guess how many articles are here on PowerPivotPro.com?  Go ahead and think of a number, I’ll wait. The answer, at time of writing, is 923.  Rob alone has published 715 articles!  And these date all the way back to 2009. A lot of these articles are “old,” but folks, the DAX engine is still 99% the same today in Power BI (and Excel 2016) as it was when it first “hit the shelves” in Spring 2010....