Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Exclusion member count

hi,

 

i have data like this :

idtype
1 
2a
3b

 

my filter selection:

type
a

b

 

if user select any type=a

 

my output data:

idtype
1 
3b

 

advance thanks,

Saikiran.

 

 

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.

     

4 Replies

  • dax's avatar
    dax
    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's avatar
      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's avatar
        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.