Measure to ignore only one filter

[Anonymous]

Hi,

i'm trying to create a total count measure for ignore only specific filter.

Here are my filters.

I want to allow ALL filter but ignore User ID filter.

I did

CALCULATE(DISTINCTCOUNT(...),ALLEXCEPT(table,table[USERID]),
        ALL(table[COMPANY],table[RICEVUTOIL],table[STABILIMENTO])))

 But it doesn't work,

thanks for help.

[v-diye-msft]

Hi @,

Please try:

Measure = CALCULATE(DISTINCTCOUNT(…),ALLEXCEPT(Table1,Table1[UserID]))

Sample shown below:

Note that the logic is mixed up using Allexcept along with All.

Best regards,

Dina Ye

[Anonymous]

Didn't works.

I want two label:

-one with selected field
-the other with the total(only some filter must modify that value), USERID MUST NOT FILTER THIS VALUE

first label is simply a measure without filter,all exc...

second label i did 

CALCULATE(DISTINCTCOUNT(…),ALLEXCEPT(Table1,Table1[UserID]))

but it doesn't work.

[v-diye-msft · Accepted solution]

Hi @Anonymous ,

Please refer to this post: https://community.powerbi.com/t5/Desktop/Make-measure-ignore-specific-filter/td-p/336870  it should help!

Best regards,
Dina Ye