Formula for count with filter

[Akhila]

Hi

I am trying to get the count of Id’s based on age group division in the dashboard.

 I am using the formula Count([Id],[age filter between 20 and 40]). But I am getting the count of the Id’s of all age groups(i.e filter is not applied).Please help with correct format

[viswanath · Accepted solution]

(Count([Id]),[age filed filter by the value between 20 and 40])

Is this format get you the result of what you expected? 

[viswanath · Accepted solution]

(Count([Id]),[age filed filter by the value between 20 and 40])

Is this format get you the result of what you expected? 

[Ayantek · Accepted solution]

Hi @Akhila ,

Please right-click on the dimension which is "age filed filter by value between 20 to 40" in your case and filter out which value you are looking for, attached screenshot for your reference.

(count([Brand ID]),[Age Range1])

Ayantek.