Using SELECTEDVALUE from a slicer to generate dynamic column

[Aditi_R]

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:

req_col = IF('dataset'[percentage] < SELECTEDVALUE('slicer'[Column1]), 1, 0)

but it is returning 0 for every entry.

Any suggestions appreciated! 

Thank you in advance!

[pratyashasamal · Accepted solution]

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-parameters

https://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

[johnt75]

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.