Create a table like a slicer

Question

HiI 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&nbsp;

daniel29195 · Accepted Answer

mihaistanca7&nbsp;&nbsp;what about changing the dax formulat in the left table to something like the following logic :&nbsp;when you select on the table visual ,&nbsp;take all the other not selected clients.would you think something like this would solve your problem&nbsp; ?&nbsp;&nbsp;&nbsp;this is the dax :&nbsp;measue =&nbsp;var d =&nbsp; values(table_name[client_column])var all_clients =&nbsp; all(table_name[client_col])&nbsp;&nbsp;var ex =&nbsp; except ( all_clients , d )&nbsp;&nbsp;var calc =&nbsp;&nbsp;calculate (&nbsp;sum(tabl_name[col]) ,&nbsp;keepfilters ( ex )&nbsp;)&nbsp;&nbsp;return&nbsp;calc&nbsp;&nbsp;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! 👍🤠

Forum Discussion

Create a table like a slicer

2 Replies

Related content

Create new table

Lakehouse Table Generate Create Table

Create rows from 2 tables

Creating date slicer removes data

Creating a dynamic slicer