Forum Discussion

Kanth's avatar
Kanth
Frequent Visitor
2 years ago

RLS with Direct Query

Hello All, We are migrating from import mode to direct query mode and would like to implement the same RLS we have in import mode. Unfortunately, our RLS uses LOOKUPVALUE function which is not suppo...
Need Help
Show and Tell
Tips and Tricks
Kanth's avatar
Kanth
Frequent Visitor
2 years ago

Looks like TREATAS function is also not allowed in direct query mode.

aj1973's avatar
aj1973
Community Champion
2 years ago

Hi Kanth 

Try

Lookup Measure = 

CALCULATE(

    MAX('Table'[ResultColumn]),

    FILTER(

        ALL('Table'),

        'Table'[SearchColumn] = SELECTEDVALUE('CurrentTable'[SearchColumn])

 

  )

)

  • Kanth's avatar
    Kanth
    Frequent Visitor
    2 years ago

    This will only work when I have only one value for a user. But, I have more than one value for a single user.