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

[Astroraf]

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? 

[AssafHanina · Accepted solution]

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

[AssafHanina · Accepted solution]

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]

@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 · Accepted solution]

@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 🙂 

[AssafHanina]

Hey @Astroraf ,

Please find Liliia syntax below

Best Regards

[Astroraf]

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]

@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: