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

     

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