Remove page filter, respect legend filter in visual

[Anonymous]

Hi everyone!

I have a table of service IDs, ages, and corrisponding age 'bucket' logic as seen below.

Id	Age	Age bucket
1	2	1-2
2	4	2-14
3	60	31 and up
4	61	31 and up
5	20	15-30
6	14	2-14
7	30	15-30
8	1	1-2
9	4	2-14

On the page that contains my visual i have a page filter to only show IDs greater than 10 days - most other visuals on this page adhear to this criteria. However i require one visual to show the count of IDs regardless of what age bucket they are in, so i write the following measure to allow that, which works great for calculating the total count (like in a card, that has no other context):

DistCountRemAge = calculate(DISTINCTCOUNT('Table'[Id]),REMOVEFILTERS(('Table'[Age])))

but when in a doughnut chart, or a matrix, in the context of the age buckets, the data from the '1-2' catagory is excluded as it does not include any values greater than 10 - but the values from the '2-14' bucket are included, as there is one value greater than 10 in that bucket.

What i would like to know, if its possible to write a measure that removes the page filter, but keep the filter in the context of the visual, IE: where all 4 buckets show in the doughnut chart and in the matrix when using this measure, and i can keep the page filter as well.

You can download the file here to take a look: 

http://www.filedropper.com/removeagefilterhelp

Thanks everyone!

[TomMartens]

Hey @Anonymous ,

as @Greg_Deckler already mentioned: it's gone and can't be brought back by using DAX alone.

Reason for this: the dreaded one-table solution (as I call it) or more educated explanation can be found in this article: https://www.sqlbi.com/articles/understanding-dax-auto-exist/

Regards,

Tom

[Anonymous · Accepted solution]

Hi @TomMartens,

Thanks so much for the article link. The solution was pretty easy, i just created a dimension table for the bucket labels and used that in the row/legend fields as you'll see below, as well as the measure i used before.

DistCountRemAge = calculate(DISTINCTCOUNT('Table'[Id]),REMOVEFILTERS(('Table'[Age])))

Thanks again!

[Greg_Deckler]

Hmm, tried a number of things and it doesn't look like it. The issue is that there appears to be pre-filtering going on where the category is getting filtered out before the DAX measure does anything. So basically it is gone in the visual and you can't bring it back via DAX as far as I can tell.