Pull information from filter in lookupvalue

[CarlosT]

i want to use lookup value in Power BI, i'm using the following expression: the problem is, i need to pull different values from table depending the result of one filter in my page. I mean the 3 er field of lookup value could be dynamic?, if one filter i choose "Private", obtain the result for this, and if i choose "Public", change the result of "Private" to "Public".

    Type_to_Freq = LOOKUPVALUE(PP_Freq[Estimate],PP_Freq[Type],"Public")

Do you know what i need to change to use that expression? Thanks.

[artemus]

Use SELECTEDVALUE(Table[ColName])