Forum Discussion

jaltoft's avatar
jaltoft
Resolver I
5 years ago
Solved

Filter card visual with table using measure

Hello,   Can someone give me some help?   This is my measure -    = IF(HASONEVALUE('Team Filter'[Name]),FIRSTNONBLANK('Team Filter'[Fullname], 1),"No selection is chosen")   I want to use th...
Need Help
  • jaltoft's avatar
    jaltoft
    5 years ago

    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.

v-robertq-msft's avatar
v-robertq-msft
Community Support
5 years ago

Hi, jaltoft 

According to your description, I can roughly understand what you want to get. But I can not figure your sample data in detail. Would you like to post some sample data in table form or pbix file(without sensitive data) and your expected result(like the chart you want to get and the correct measure value based on your sample data)?

Thanks very much!

How to Get Your Question Answered Quickly 

 

Best Regards,

Community Support Team _Robert Qin

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • jaltoft's avatar
    jaltoft
    Resolver I
    5 years ago

    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

     

    v-robertq-msft 

    • jaltoft's avatar
      jaltoft
      Resolver I
      5 years ago

      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.