Forum Discussion
Using SELECTEDVALUE from a slicer to generate dynamic column
Hello everyone,
I have a table of student performance (percentage marks in each subject).
I have a slicer for values 5,10,15,...,100. If the user selects the value say 40, I want to create a column which will store 1 if the percentage obtained by the student is less than 40 and 0 otherwise.
I tried using:
Hi Aditi_R ,
I would suggest using parameters for Columns slicer and then creating a measure out of it.
You can refer to these links:-
https://learn.microsoft.com/en-us/power-query/power-query-query-parametershttps://www.sqlbi.com/articles/using-the-selectedvalue-function-in-dax/
Hope this is helpful.
Thanks ,
Pratyasha Samal
Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C
2 Replies
johnt75Super User
Calculated columns are only calculated during data load or refresh, so they do not pay any attention to slicers or filters. If you want something which will react dynamically you will need to do it as a measure.
- pratyashasamal
Memorable Member
Hi Aditi_R ,
I would suggest using parameters for Columns slicer and then creating a measure out of it.
You can refer to these links:-
https://learn.microsoft.com/en-us/power-query/power-query-query-parametershttps://www.sqlbi.com/articles/using-the-selectedvalue-function-in-dax/
Hope this is helpful.
Thanks ,
Pratyasha Samal
Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C