Dynamic CREATETABLE based on selection in slicer

[Anonymous]

Hi guys,

I have been trying to figure this one out for few hours now and stil lcannot get it done.

I have a general ledger detail with all journal entries for the period (fact table).

I have a dimension table with account numbers (distinct values).

I would like to create a new table which will filter the list of all journal entry numbers from the fact table based on the accounts selected in the slicer created from the dimension table.

I am not interested in doing this in visualisation as this would be just a defaul Power BI behaviour considering relationship between dimension and fact table.

I would like to create the aforementioned table in "Data" view of Power BI. (i.e. literaly creating a new table in my data model)

I plan to use this newly created table for other DAX functions filtering the data set.

Many thanks,

Ray

[lbendlin]

You cannot create tables (or columns) from measures (or user filters).