Count by another column which has discount value greater than 1

[Dn_wemn]

Hi,

I'd like to count the products which have more than one brand.

So in this example, the measure count should be 4. It should count the products C, D, E and F. These products have multiple distinct brands.

Product	Brand	RandomColumn
A	ds	k
A	ds	j
B	n	g
C	mu	t
C	o8	r
C	g	w
D	kl	e
D	zzz	r
E	red	t
E	vf	z
E	mnn	u
F	awh	b
F	lhf	c
F	kjk	x
F	mk	s
G	AA	e
G	AA	u

Thank you.

[JamesFR06 · Accepted solution]

Mesure 5 =
VAR base =
COUNTROWS (
FILTER (
SUMMARIZE (
Brand,
Brand[Product ],
"Brand",
CALCULATE (
DISTINCTCOUNT ( Brand[ Brand] ),
ALLEXCEPT ( Brand, Brand[Product ] )
)
),
[Brand] > 1
)
)
RETURN
base

[Dn_wemn]

Thanks a lot 🙂

[JamesFR06]

Hi,

NbBrand = CALCULATE(DISTINCTCOUNT(Brand[ Brand]),ALLEXCEPT(Brand,Brand[Product ]))

[Dn_wemn]

Hi,

I'd like to count the products which have more than one brand, so the brands should not be counted.

The expected total result should be 4.