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