Forum Discussion

jonathangsanto's avatar
jonathangsanto
Icon for Helper I rankHelper I
4 years ago
Solved

How get data in selected filters

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?

 

Need Help
  • AilleryO's avatar
    AilleryO
    4 years ago

    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...

2 Replies

  • AilleryO's avatar
    AilleryO
    Icon for Memorable Member rankMemorable Member
    4 years ago

    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...
  • jonathangsanto's avatar
    jonathangsanto
    Icon for Helper I rankHelper I
    4 years ago

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