Disconnected Slicers With DAX Variables And SELECTEDVALUES

Video by Reid Havens - Founder of Havens Consulting and contributing author at P3
https://www.havensconsulting.net

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]
)

Видео Disconnected Slicers With DAX Variables And SELECTEDVALUES канала PowerPivotPro