Blox TextBlock - Remove Filters for Value

Question

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 example, the count changes as the user applies filters. As the user applies the filters, the bottom text block should not be affected by the filters (except for the given year they are in). In this example, the total count for the year is 27,690 which should stay the constant so the user can see For...

TriAnthony · Accepted Answer

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 n...