Slicer based Filtering to create a calculated Summarised table

[anwarbi]

Hello,

I am trying to create a table by summarising another table using the below dax.

While i have been able to create the summarised table but I would like to make the Global_Clients filter (in below dax- MVA Group) a dynamic selection based on the slicer value rather than manually typing in the dax.

Is there a way i can create a slicer based selection for Global_clients in the below dax.

Table with Unique ID = SUMMARIZE(FILTER('Working data (placed)','Working data (placed)'[GLOBAL_CLIENTS]= "MVA Group"),'Working data (placed)'[Unique Key],'Working data (placed)'[GLOBAL_CLIENTS],'Working data (placed)'[Metric])

Thank you for your help.

Anwar

[Daniel29195]

hello @anwarbi , 

i understand that you want to create a calculated table that would be affected by a slicer 

calculated tables on creation, cant be affected by the filter context 

but you can link other tables to it, to filter the data of the table .

let me know if i answered your question,

if not, can you please give a visual representation of what you want achieve. it would help alot. 

best regards