Create a table like a slicer

[mihaistanca7]

Hi

I have this situation where in the felt table there is some calculated data.

I must display these positions in multiple scenarios, without first 3 clients, than without first 7 , 15 and so on based on their total value.

I initially tried to use table as filter visual but i do not have possibility to make all clients default "all selected" than to deselect first 3, 5...

When i use slicer, it doesn't let me to insert a second column with total value near client name.

In this example i deselected first 5 clients so the value in the left table is 418,221 instead of 985,829 which is in the "filer table"

Any ideea about how can i solve this?

Thank you

[Daniel29195 · Accepted solution]

@mihaistanca7 

what about changing the dax formulat in the left table to something like the following logic : 
when you select on the table visual , 

take all the other not selected clients.

would you think something like this would solve your problem  ? 

this is the dax : 

measue = 

var d =  values(table_name[client_column])
var all_clients =  all(table_name[client_col]) 

var ex =  except ( all_clients , d ) 

var calc =  

calculate ( 

sum(tabl_name[col]) , 

keepfilters ( ex ) 
) 

return 

calc

If my answer helped sort things out for you, feel free to give it a thumbs up and mark it as the solution! It makes a difference and might help someone else too. Thanks for spreading the good vibes! 👍🤠

[mihaistanca7]

Good ideea:)

Thank you