Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
Solved! Go to Solution.
Mesure 5 =
VAR base =
COUNTROWS (
FILTER (
SUMMARIZE (
Brand,
Brand[Product ],
"Brand",
CALCULATE (
DISTINCTCOUNT ( Brand[ Brand] ),
ALLEXCEPT ( Brand, Brand[Product ] )
)
),
[Brand] > 1
)
)
RETURN
base
Mesure 5 =
VAR base =
COUNTROWS (
FILTER (
SUMMARIZE (
Brand,
Brand[Product ],
"Brand",
CALCULATE (
DISTINCTCOUNT ( Brand[ Brand] ),
ALLEXCEPT ( Brand, Brand[Product ] )
)
),
[Brand] > 1
)
)
RETURN
base
Thanks a lot 🙂
Hi,
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.
User | Count |
---|---|
98 | |
90 | |
82 | |
73 | |
67 |
User | Count |
---|---|
115 | |
102 | |
98 | |
71 | |
67 |