How to display totals of values filtered out?

[NicoleTy]

Hi,

I have a table imported into the data model. It has mulitple columns C1, C2, C3. C1 is a set of numbers, C2 and C3 are categories of C1 like State and Zipcode. We need to filter C1 for values under a threshold so the distribution is more clear. We also need to know how many values we filtered out when we apply the threshold.

I duplicated C1 to another query and only get the static total count of the values > threshold, when I change C2 and C3, the value does not change. Is there a way to make it display in the same report view?

Thanks,

-Nicole

[SqlJason]

Can you paste some sample data on what the source looks like, and what you need the results look like? Would help us to understand your scenario as well as the logic better.

You should be using a measure to do the filtering as well as get the counts, and not a calculated column. If you do it with a calculated column, the values would be static and would not change while filtering C2 and C3. Hopefully, I (or someone else in the forum) will be able to give you the exact formula if you paste the source data.

[kazlik]

As mentioned look to do this in a measure and if you are then filtering data but still need to get a value from a filtered out value look to use something like ALL, ALLEXCEPT or VALUES in the measure.

http://sqlblog.com/blogs/marco_russo/archive/2010/04/05/all-allexcept-and-values-in-dax.aspx