View My Drafts
In this tutorial, I'll show you how to harvest or capture a value inside a measure to reuse in another measure and achieve dynamic calculations. I use a combination of measure branching technique with SELECTEDVALUE DAX function in Power BI.
The Power BI team have made some updates to formulas recently that enable this to work in a far more effective way than what had to be done previously. You may watch the full video of this tutorial at the bottom of this blog.
It's not difficult to do, so let's jump into it