Preventing measure from being affected by visual filters

Question

I am trying to stop this measure from being affected by visual filters:

DIVIDE(
   CALCULATE(
       COUNTROWS('Table1'), 
         FILTER('Table1', 'Table1'[column1]="High")),
         COUNTROWS('Table1'))

I have tried adding the ALL function after the COUNTROWS and FILTER function but this did not work.

Any ideas?

Answer 1

If I understand your question, removing CALCULATE and just using ALL as a table function that ignores any existing filter context should work

DIVIDE(
    COUNTROWS( FILTER( ALL( 'Table1' ), 'Table1'[column1] = "High" ) ),
    COUNTROWS( ALL( 'Table1' ) )
)

In case you need to satisfy slicers, you might use ALLSELECTED instead of ALL