Forum Discussion

Anonymous's avatar
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
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • dax's avatar
    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.