DAX for Power BI - Dynamic Relationship by Selection

[@NormRidg]

Like the nice simple example in less than 10 minutes. Very clearly done. Looking forward to viewing more of your training videos.

[@BIElite]

Glad you got something out of it! And thanks for the feedback

[@AndrewMSeward]

Hi great tutorial - Thanks!! note I tend to use SELECTEDVALUE function to harvest the value from the disconnected slicer. Its useful that it returns NULL if more than one or none are selected.

[@BIElite]

+Andrew Seward thanks for the tip! That does sound useful. FIRSTNONBLANK is just a habit for me at this point

[@AndrewMSeward]

BI Elite yea the selected values is a daily new function and only available in PowerBI (not in power pivot for excel)

[@komanguy]

Thanks a lot.

[@BIElite]

No problem Guy!

[@rrrprogram8667]

I would have used SELECTEDVALUE instead of FIRSTNOBLANK function..... the later is generally used for other purpose right ..... what do you say ??

[@BIElite]

You may be right about that. I'd have to try it out but I bet the SELECTEDVALUE would do the trick. I always lazily use FIRSTNONBLANK just because I know it works on getting the selected value but I might have to revisit this