Forum Discussion

anwarbi's avatar
anwarbi
Helper III
2 years ago

Slicer based Filtering to create a calculated Summarised table

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
Need Help

1 Reply

  • Daniel29195's avatar
    Daniel29195
    Community Champion
    2 years ago

    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