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 followin...
Need Help
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