Forum Discussion

HQ_Dev_Prod's avatar
HQ_Dev_Prod
Cloud Apps
03-11-2025
Solved

Blox TextBlock - Remove Filters for Value

I am attempting to add a textblock to my Blox KPI with a calculated value. The objective is for the total value to stay the same as a point of comparison, while the user applies filters. In this exa...
dashboards & reporting
  • TriAnthony's avatar
    TriAnthony
    03-13-2025

    Hi HQ_Dev_Prod,

    For the filtered count, did you mean to ignore the Month and Year filter for this measure? If so, the syntax of your formula is incorrect. Each filter that you want to bypass needs to be in it's own ALL function. The correct formula should be:

    COUNT (Item_Unique_ID),  ALL([Months in date]), ALL([Years in Date]) )

    For the total count, you mentioned it "should not be affected by the filters (except for the given year they are in)." Does this mean the filtered count will not be affected by the Year filter (because you use ALL function in the formula), but the total count will be affected by it? Either way, you can use the ALL function to ignore filters. So the formula for the total count would be like this:

    COUNT (Item_Unique_ID),  ALL([dashboard_filter1]), ALL([dashboard_filter2]), ALL([dashboard_filter3]), ALL([dashboard_filter4]), etc... )

    Please let me know if this is helpful.

    -Tri

TriAnthony's avatar
TriAnthony
Sisense Employee
03-13-2025

Hi HQ_Dev_Prod,

For the filtered count, did you mean to ignore the Month and Year filter for this measure? If so, the syntax of your formula is incorrect. Each filter that you want to bypass needs to be in it's own ALL function. The correct formula should be:

COUNT (Item_Unique_ID),  ALL([Months in date]), ALL([Years in Date]) )

For the total count, you mentioned it "should not be affected by the filters (except for the given year they are in)." Does this mean the filtered count will not be affected by the Year filter (because you use ALL function in the formula), but the total count will be affected by it? Either way, you can use the ALL function to ignore filters. So the formula for the total count would be like this:

COUNT (Item_Unique_ID),  ALL([dashboard_filter1]), ALL([dashboard_filter2]), ALL([dashboard_filter3]), ALL([dashboard_filter4]), etc... )

Please let me know if this is helpful.

-Tri