Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredJoin us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM. Register now.
I have created a measure based on filter selection using the SELECTEDVALUE function.
SelectedRecency = SELECTEDVALUE('Input Files'[Recency], 0)
Using the measure, I am able to show the filter selection correctly on a card.
However, when I am trying to use this measure to create a calculated column
Recency_test = [SelectedRecency],
it is replicating the column 'Input Files'[Recency] instead of just creating the column with one value obtained from the filter selection
Is it not possible to create a dynamic filter selection based column in power bi, if yes, how?
Your help is appreciated. Thanks!
Hi @ankitv0407,
I'm afraid we can't create a dynamic filter selection based column for now. I would suggest you vote up this idea or create a new one.
Best Regards,
Dale
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
Check out the October 2025 Power BI update to learn about new features.
| User | Count |
|---|---|
| 76 | |
| 37 | |
| 31 | |
| 29 | |
| 26 |