Computer-Play-Button_thumb2

Disconnected Slicers With DAX Variables & SELECTEDVALUES

Hello P3 Nation! Today’s “post” is actually going to be a video link. Sometimes there are certain subjects, concepts, or post ideas that just don’t translate well to the written word, and especially to screenshots. So this post will be in moving picture form! We’ve posted it to our YouTube Channel which you can go to here. Bedside’s today’s video, we have TONS of content on that channel so please take a look at our other awesome videos as well.

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!

Value Selection =
VAR Selection =
SELECTEDVALUE ( ‘Value Selection'[Value Selection], “All” )
RETURN
SWITCH (
TRUE (),
Selection = “Actuals”, [Sales Amount],
Selection = “Budget”, [Budget Amount],
Selection = “Forecast”, [Forecast Amount],
[Sales Amount]
)