Forum Discussion

Anonymous

Not applicable

6 years ago

Solved

Exclusion member count

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...

Data Protection

General Comment

Interesting Links

Tips and Tricks

Tutorial Requests

dax
6 years ago
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.

Community Support

6 years ago

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
Not applicable
6 years ago
Sir,

Small Help same as my request.

output count:
if user select type :A
my count should be 3-1=2
- dax
  Community Support
  6 years ago
  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.