Forum Discussion
Pull information from filter in lookupvalue
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.
1 Reply
Use SELECTEDVALUE(Table[ColName])
