Forum Discussion

Astroraf's avatar
Astroraf
Data Pipeline
02-03-2025
Solved

How to have the secondary value in an Indicator Widget not be affect by Dashboard Filters

Hi DRay Liliia_DevX ,

I am curious: if a customer wants to have a formula in the second indicator widget not affected by the dashboard filters, how would one go about doing this?

My solution would be:

COUNT(coloumn_name, ALL(dim_value))

Would this be correct? 

  • Hey Astroraf ,

    The Syntax shared is a valid solution.
    The ALL Function ignore the scope of the filter (See related documentation)

    Example of Using the same measure twice with and without All Function

    Best regards

  • Astroraf hi! If you like to have multiple dimensions not be affected by dashboard filters, the syntax should look like on the screenshot below:

    Feel fee to test it from your side 🙂 

6 Replies

  • AssafHanina's avatar
    AssafHanina
    Sisense Employee

    Hey Astroraf ,

    The Syntax shared is a valid solution.
    The ALL Function ignore the scope of the filter (See related documentation)

    Example of Using the same measure twice with and without All Function

    Best regards

  • Astroraf's avatar
    Astroraf
    Data Pipeline

    AssafHanina Thank you got this solution. My only question is say I have multiple filters. Could this still apply?

    example: SUM(COUNT([ID]), ALL([dim_val1], [dim_val2], [dim_val3]))

    • Liliia_DevX's avatar
      Liliia_DevX
      Sisense Employee

      Astroraf hi! If you like to have multiple dimensions not be affected by dashboard filters, the syntax should look like on the screenshot below:

      Feel fee to test it from your side 🙂 

  • Astroraf's avatar
    Astroraf
    Data Pipeline

    Hi Liliia_DevX and AssafHanina,

    I have another step to this process. Not sure if it has already been asked, but I need a calculation to not change with any filtering. How would I achieve this?

    • Liliia_DevX's avatar
      Liliia_DevX
      Sisense Employee

      Astroraf hi!

      The only way to do that on a formula level is to include all dimensions used in filters with ALL() function. 

      Another approach is to create an indicator with one value and just toggle off all dashboard filters in the widget edit mode: