Forum Discussion

caleboud's avatar
caleboud
Frequent Visitor
3 years ago

Counting customers that share multiple sales groups

I make selections in a slicer and count the selections I make

 

Then I count the groups and blank the ones that are not equal to the number of selections made.

This results in following tables

What i need is to count the customers that are in the table with 11 MG Count

As you can see in the left table there is only one customer haveing all three groups.

 

 

 

 

 

Need Help

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi caleboud ,

     

    Due to I don't know your data model, here I will give you some suggestions. I think you can try this code to create a measure.

    Percentage =
CALCULATE (
    COUNT ( 'Table'[Door.Door Level01.Key] ),
    FILTER ( Table, [11 MG Count] <> BLANK () )
)

     If this reply still couldn't help you solve your problem, please share a sample file to me and show me a screenshot with the result you want. This will make it easier for me to find the solution.

     

    Best Regards,
    Rico Zhou

     

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

    • caleboud's avatar
      caleboud
      Frequent Visitor
      3 years ago

      Hi Rico,

       

      Thanks for your answer.

      This will still give me the following table while i only need to count the door that has the 3 groups.

      Somehow i would need to filter the one with total = 3