How get data in selected filters

[jonathangsanto]

Hi All,

I have 2 cards, each filtering information

Each of this information has a geographic location in my table

I need to get these coordinates based on the filter to calculate the distance between the points.

I tried:

Filters Selected =

IF (

ISFILTERED ( BH_gold[NumeroSerie] ),

CONCATENATEX ( FILTERS ( BH_gold[NumeroSerie] ), BH_gold[NumeroSerie], ", " ),

"ALL"

)

But that takes just one filter

can anyone help me?

[jonathangsanto]

I used what you recommended and I set up the table model and it worked perfectly, thanks

[AilleryO · Accepted solution]

Hi,

You could try :

Filters Selected =
VAR TempTable = SELECTCOLUMNS( BHGold, BH_gold[NumeroSerie] ) //Selet columns needed
VAR ListFilter1="*" & CONCATENATEX(TempTable , "," & BH_gold[NumeroSerie] ) //creation of string

VAR ListFilter2 = SUBSTITUTE(DelimList1,"*-","") //cleaning of string

RETURN
ListFilter2

Tell us if it works...