Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi,
Is it possible to populate a column based on user selection ?
I have a table '2'[userinput] with values "a" and "b".
I am giving the user the choice to select from these values.
I want to populate a column in my other table as:
NewValue =
Solved! Go to Solution.
Hi @Saniat ,
According to your description, measures are applicable, calculated columns are not.
Measures are calculated on demand based on the report selections, not the refreshed the data. So your measure in the column is calculated on demand, in the case of the column it is at data refresh.
In other words, measures are dynamic, while calculated columns are static.
Therefore, you can use the SELECTEDVALUE() function to create a measure to return dynamic values.
Measure =
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Saniat ,
Is your problem solved, please?
If it is solved, please mark the helpful reply as a solution, more people will benefit.
Best Regards,
Stephen Tao
Hi @Saniat ,
According to your description, measures are applicable, calculated columns are not.
Measures are calculated on demand based on the report selections, not the refreshed the data. So your measure in the column is calculated on demand, in the case of the column it is at data refresh.
In other words, measures are dynamic, while calculated columns are static.
Therefore, you can use the SELECTEDVALUE() function to create a measure to return dynamic values.
Measure =
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Check if field parameters can help
Power BI Field Parameters — A Quick way for Dynamic Visuals: https://amitchandak.medium.com/power-bi-field-parameters-a-quick-way-for-dynamic-visuals-fc4095ae9af...
Or old approach
How to create a Measure Slicer: https://youtu.be/b9352Vxuj-M
User | Count |
---|---|
96 | |
87 | |
78 | |
72 | |
68 |
User | Count |
---|---|
113 | |
105 | |
84 | |
65 | |
64 |