Forum Discussion
Create a table like a slicer
- 2 years ago
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! 👍🤠
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! 👍🤠
- mihaistanca72 years agoFrequent Visitor
Good ideea:)
Thank you