Forum Discussion

PPStar's avatar
PPStar
Helper V
3 years ago

Filters on Tooltips

Hi,  I have the following pages on my power bi repot   Page 1 - Page 1 has a filter on its page to only show data where the Section = HR Page 2 - Page 2 has a filter on its page to only show data...
Need Help
amitchandak's avatar
amitchandak
Super User
3 years ago

PPStar , the section of measure should filter based on the same filter you use on page.

 

Assume the filter is page name

 

calculate([Value measure], filter(Table, Table[Section] = selectedvalue(Page[Name]) )

  • PPStar's avatar
    PPStar
    Helper V
    3 years ago

    i dont understand this. 

    what is value measure?. 

    • NikhilChenna's avatar
      NikhilChenna
      Skilled Sharer
      3 years ago

      Hi PPStar ,

       

      Use this below measure,

       

      Section     | Value 

      HR            | 10

      Finance     | 14

      Marketing | 12

       

      Measure = calculate(SUM([Value]), filter(Table, Table[Section] = selectedvalue(Page[Name]) )

       

      Regards,

      Nikhil Chenna

       

      Appreciate with a Kudos!! (Click the Thumbs Up Button)
      Did I answer your question? Mark my post as a solution!

       

      • PPStar's avatar
        PPStar
        Helper V
        3 years ago

        OK, i got the first part, dont understnad the second part SelectedValue(Page[Name]))

         

        The SelectedValue is looking for a column Name when i enter page its greys out, do i have to hardcode the page name?

         

        apologies for the basic questions, im a newbie.