Forum Discussion
Filter card visual with table using measure
Hello I have found the solution to this. It is a very simple solution, keep above measure and filter out other roles in card visual by adding user role into the filter.
Hello,
It wouldnt let me paste a table. The below shows an example of my teams table linked to the main dataset. I am trying to get the card to show a team managers name (Fullname) when clicking on a table below it, in this it will show a count of total cases by Team name.
Please see below -
UserRole Name Fullname
Admin Team 1 John Smith
Team Manager Team 1 Joe Bloggs
System user Team 1 Micky Mouse
System user Team 1 Minne Mouse
System user Team 1 Homer Simpson
System user Team 1 Bart Simpson
System user Team 1 Marge Simpson
System user Team 1 Maggie Simpson
System user Team 1 Lisa Simpson
Admin Team 2 Bill Smith
Team Manager Team 2 Barney Gumble
System user Team 2 Danger Mouse
System user Team 2 Clancy Wiggum
System user Team 2 Dewey Largo
System user Team 2 Kent Brockman
System user Team 2 Millhouse Van Houten
System user Team 2 Ned Flanders
System user Team 2 Nick Riviera
Hello I have found the solution to this. It is a very simple solution, keep above measure and filter out other roles in card visual by adding user role into the filter.