Forum Discussion

Ritaf's avatar
Ritaf
Icon for Responsive Resident rankResponsive Resident
4 years ago
Solved

remove filters from filter pane and keep inside visual

Hi,
I need to ignore the filter on page level and keep the filter on the same column inside the vizual.

How can I manipulate this issue with DAX?

Need Help
Show and Tell
  • v-easonf-msft's avatar
    v-easonf-msft
    4 years ago

    Hi， Ritaf 

    Have you tried measure like:

    New Measure =
CALCULATE (
    'Table'[Measure],
    FILTER ( ALL ( 'Table' ), 'Table'[Category] = MAX ( 'Table'[Category] ) )
)

    You can also remove page-level filters and custom visual-level filters for each visual on this page.

     

    Best Regards,
    Community Support Team _ Eason

     

3 Replies

    • Ritaf's avatar
      Ritaf
      Icon for Responsive Resident rankResponsive Resident
      4 years ago

      Hi,
      Thank you for your response, but this is not my case.
      I have a category with names and need to show measures filtered by every category on a specific visual.

  • v-easonf-msft's avatar
    v-easonf-msft
    Icon for Community Support rankCommunity Support
    4 years ago

    Hi， Ritaf 

    Have you tried measure like:

    New Measure =
CALCULATE (
    'Table'[Measure],
    FILTER ( ALL ( 'Table' ), 'Table'[Category] = MAX ( 'Table'[Category] ) )
)

    You can also remove page-level filters and custom visual-level filters for each visual on this page.

     

    Best Regards,
    Community Support Team _ Eason