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 the measure to add into a card to show the [Fullname] of the person however in my data I also have a [userole].
I need this measure to work only selecting "Team managers" as there will be one per team.
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.

3 Replies

  • 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.