Forum Discussion

fabiopaturzo's avatar
fabiopaturzo
Icon for Helper I rankHelper I
2 years ago
Solved

Filter Table by SELECTEDVALUE and Slider

Hi 
starting from ItemLedgerEntriesnew table where i have record with a colomn( Posting_date) i would like to create a new table "AggregatedTable" filtering by  'Misure'[DataSelezionata] 
 
AggregatedTable =
  FILTER(
        'ItemLedgerEntriesnew',
         'ItemLedgerEntriesnew'[Posting_Date] < 'Misure'[DataSelezionata]
    )
 
where 
 
DataSelezionata = SELECTEDVALUE(Datenuove[Data])
  and
 
Datenuove is a table  and I select the data with a slider
 

 

I don't have any result it seem the 'Misure'[DataSelezionata] is always blanck

 

  • Anonymous's avatar
    Anonymous
    2 years ago

    HI fabiopaturzo,

    Currently power bi does not support to create dynamic calculated column or tables based on filter effects. They not work on the same level and you can't use the child level to affect their parent.

    Notice: the data level of power bi(from parent to child level)

    Database(external) -> query table(query, custom function, query parameters) -> data model table(table, calculate column/table) -> data view with virtual tables(measure, visual, filter, slicer)

    Regards,

    Xiaoxin Sheng

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    HI fabiopaturzo,

    Currently power bi does not support to create dynamic calculated column or tables based on filter effects. They not work on the same level and you can't use the child level to affect their parent.

    Notice: the data level of power bi(from parent to child level)

    Database(external) -> query table(query, custom function, query parameters) -> data model table(table, calculate column/table) -> data view with virtual tables(measure, visual, filter, slicer)

    Regards,

    Xiaoxin Sheng