How can I keep page filters acitive - using a measure that calculates a grand total?

[TRK]

Hi,

I currently have a page filter that filters out one country in the Country of Origin column.

I need to calculate a % of the a total number of samples that come from any one country, or program, etc., selected on the dasboard visualizations against the total unfiltered samples (excluding the one country I filtered out using the page filter) .

I want the the total unfiltered samples is the same amount no matter which filters are applied on the dashboard (such as program) - excluding the page filter for the one country.

I have been experimenting with CALCULATE AND ALL functions - but it is not working - I realize the last "ALL" for country lookup would be discounting all filters on country - not sure what function I could use to keep the page filter active or a method that would do the equivelant.

unfiltered samples = CALCULATE('sample data'[sum samples],

                                   ALL ('Program Lookup'[Program]) ,

                                   ALL ('Country Lookup'[Country of Origin]))

My goal :  % of samples = [sum samples]/[unfiltered samples]

any suggestions are appreciated.

-TRK

[Greg_Deckler]

I believe you want to use ALLEXCEPT.

[TRK · Accepted solution]

Unfortunately "ALLEXCEPT" ends up filtering out all countries in the total counts.  I want to keep all the countries in the "country of origin" column, except the one country I filtered out on the page filter (this allows me to filterout domestic vs. imported samples).

Any other ideas?

[TRK]

Hi,

I realized I had a relationship line missing.  I went back and tried ALLEXCEPT again.  It worked.

Thank-you!

[v-shex-msft]

Hi @TRK,

>>Any other ideas?

I'd like to suggest you use "ALLSELECTED" to instead the "ALL" function.

Regards,

Xiaoxin Sheng