Filtering through properties of a dimension and not by the dimension it self

[VictorBoscaro]

I have a table like this

And I want to have a filter in my app that will have the name of the conselour (no_conselheiro) but when selected, the filter will be by those dates. The dates will be in a variable, and the variable will be used to filter a card.

How can I do this?

[brunobertels]

Hi 

Here a first approach to test  

to get the list of possible date depending of selection made in Dim no_conseilheiro : 

If(GetselectedCount(no_conseilheiro ) >0 ,Concat(DISTINCT YourDateField,', '))

So now you may be able to create a variable with somethink like this 

Set vMyVariable = chr(39)&If(GetselectedCount(no_conseilheiro ) >0 ,Concat(DISTINCT YourDateField,', '))&chr(39)

it may listed the date like this : 

and then use your variable by calling it using $(vMyVariable) or $(=vMyVariable) to filter your card 

Hope it helps