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? 

Dashboards & Reporting
  • AssafHanina's avatar
    AssafHanina
    02-04-2025

    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

  • Liliia_DevX's avatar
    Liliia_DevX
    02-04-2025

    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
    02-04-2025

    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
    02-04-2025

    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
      02-04-2025

      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
    02-07-2025

    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
      02-07-2025

      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: