cancel
Showing results for 
Search instead for 
Did you mean: 

Blox TextBlock - Remove Filters for Value

HQ_Dev_Prod
9 - Travel Pro
9 - Travel Pro

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 filtered count, I have value function ( COUNT (Item_Unique_ID),  ALL([Months in date], [Years in Date]) )

Not sure how to rewrite this so the bottom portion of the text block stays this exact number of 27,690 as the user applies filters. 

 

HQ_Dev_Prod_0-1741713416547.png

 

1 ACCEPTED SOLUTION

TriAnthony
Community Team Member
Community Team Member

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

Tri Anthony Situmorang

View solution in original post

2 REPLIES 2

TriAnthony
Community Team Member
Community Team Member

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

Tri Anthony Situmorang

DRay
Community Team Leader
Community Team Leader

Hello @HQ_Dev_Prod,

I’m following up to see if the solution offered by @TriAnthony worked for you.

If so, please click the 'Accept as Solution' button on the appropriate post. That way other users with the same questions can find the answer. If not, please let us know so that we can continue to help.

Thank you.

David Raynor (DRay)

Type a product name