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

     

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