Exclusion member count

[Anonymous]

hi,

i have data like this :

id	type
1
2	a
3	b

my filter selection:

type

a

b

if user select any type=a

my output data:

id	type
1
3	b

advance thanks,

Saikiran.

[dax]

Hi @Anonymous , 

You could refer to my sample to create measure, then set filter like below

Best Regards,
Zoe Zhi

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Sir,

Small Help same as my request.

output count:

if user select type :A

my count should be 3-1=2 

[dax · Accepted solution]

Hi @Anonymous , 

You could add another measure like below

count = if(HASONEVALUE('Table'[id]), SUM('Table'[id]),CALCULATE(MAX('Table'[id]), FILTER(ALLSELECTED('Table'), [Measure]=1))-CALCULATE(MIN('Table'[id]), FILTER(ALLSELECTED('Table'), [Measure]=1)))

Best Regards,
Zoe Zhi

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[lbendlin]

https://docs.microsoft.com/en-us/dax/except-function-dax