Forum Discussion

Günter's avatar
Günter
Regular Visitor
9 years ago
Solved

How to disable 'Visual Level Filter' ?

Hi all,   I'm just a bigenner in data visualization. I'm trying to disable 'Visual Level Filter' that make my visualization static. More detail, actually, my I just put data in a table (Year, budg...
Need Help
  • v-ljerr-msft's avatar
    v-ljerr-msft
    9 years ago

    Hi Günter,

     

    If I understand you correctly, you can make use of ALL Function (DAX) which returns all the rows in a table, or all the values in a column, ignoring any filters that might have been applied to create new measures for the values you want to show statically.

     

    For example, if you want to show the budget statically on the table, you can just use the formula below to create a new measure, then show the measure on the table.:smileyhappy:

    Budget_Measure = CALCULATE ( SUM ( 'YourTableName'[Budget] ), ALL ( 'YourTableName' ) )

     

    Regards

v-ljerr-msft's avatar
v-ljerr-msft
Microsoft Employee
9 years ago

Hi Günter,

 

If I understand you correctly, you can make use of ALL Function (DAX) which returns all the rows in a table, or all the values in a column, ignoring any filters that might have been applied to create new measures for the values you want to show statically.

 

For example, if you want to show the budget statically on the table, you can just use the formula below to create a new measure, then show the measure on the table.:smileyhappy:

Budget_Measure = CALCULATE ( SUM ( 'YourTableName'[Budget] ), ALL ( 'YourTableName' ) )

 

Regards