Create a new Measure to show only the value based on another coloumn

[gracie494]

For this table below, I would like to see a new coloumn  that only shows the "Active Learner" value where the Latest Status is 1. 

Year	quarter	active learner	Status	Latest Value quarter
2021	Q1	26
2021	Q2	26
2021	Q3	26
2021	Q4	26	1	26
2022	Q1	13
2022	Q2	13
2022	Q3	13
2022	Q4	13	1	13

[technolog]

I hope this message finds you well. I've noticed that this solution remain unresolved. If any of you have managed to find a resolution to the issue, I kindly request that you share your solution for the benefit of the entire community. Alternatively, if you're still facing challenges, please do let us know as well.

Your insights and updates will greatly assist others who might be encountering the same challenge.

[Girish_123]

Latest value = CALCULATE(SELECTEDVALUE('Table'[Active learner]),FILTER('Table',SELECTEDVALUE('Table'[Status])=1))

[gracie494]

Hi, it does not work because the status is numberic so when I try the filter for 'FILTER('Table',SELECTEDVALUE('Table'[Status])=1))' The status coloumn does not appear or not valid

[Girish_123]

if your status column is text data type then wrap 1 with double quotation "1" then try

[gracie494]

The status coloumn is 'Numeric' but it does not appear as an option to select with the 'selectedvalue' function... not sure if its because its also a calculated meaure

[ERD]

@gracie494 , you can use a measure 

learner = IF(SELECTEDVALUE(Table[Status]) = 1, SELECTEDVALUE(Table[active learner]))

[gracie494]

No it does not work unfortunately, it does not recognise the field 'Last Status' as a field... maybe because it is already a measure

[ERD]

Status is a measure?

learner = IF( [Status] = 1, SELECTEDVALUE(Table[active learner]))

[gracie494]

Thanks the formular is right but it does not return the value in the Active Values Coloumn as its numeric... this only works if the 'Active Values Coloum' was a text field