Forum Discussion

mihaistanca7's avatar
mihaistanca7
Frequent Visitor
2 years ago
Solved

Create a table like a slicer

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 ba...
  • Daniel29195's avatar
    2 years ago

    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! šŸ‘šŸ¤