Return all associated ID to use at IN Filter

[marcio_fornari]

Hi,

I have a table "D_CLINICAS" that one ID has many tenant_id associated.

I need use this values like IN expression values at RLS FILTER. (tenant_id IN {4,1511,5820,7891}

My dax return this values

 Expression on RLS

 When i test this Role, Broken the visuals and says: 

"Can not convert the values '7891,4,1511,5820' of type text to number type"

[amitchandak · Accepted solution]

@marcio_fornari , Create a table in var and use that in IN

example

measure =
var _tab = summarize(filter(Table,{empresa_id]=4),[tenant_id])
return
calculate(sum(Table[Value]), filter(Table,Table[tenant_id] in _tab))

[marcio_fornari]

@amitchandak Works like a charm!!! 

Thank you so much guy!