Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Creating a measure that uses page filter

Hi Hope all is well

 

I'm kind stuck on something that is really confusing me any help will be appreciated. Is there anyway to create a measure that uses a page filter ? 

Need Help
Show and Tell
Tutorial Requests

3 Replies

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    6 years ago

    Anonymous , Not very clear.

     

    The measure should filter of page filter. 

     

    The information you have provided is not making the problem clear to me. Can you please explain with an example.

    Appreciate your Kudos.

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Thanks for the reply amitchandak , sorry for the informative example .  So currently I have created this measure

      (Zero Measure = Sum('Query1'[count(transaction_id)]) + 0) to calcuate when a company has made zero updates on the application. I also have a filter for company_name column which only selects the companies I want.  However it seem when I add this measure with the company_name column to a visual it shows even the companies I have filtered out . My question is what would be causing this issue ? and how can it be fixed . Hopefully you made sense from that 

       
       
       

       

      • v-diye-msft's avatar
        v-diye-msft
        Icon for Community Support rankCommunity Support
        6 years ago

        Hi Anonymous 

         

        You might consider providing your dummy pbix that would be helpful for us to investigate it further. 

        You can upload it to the onedrive for business and share the link here. please don't forget to disclose the expected results and remove the confidential info.