Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
102 | |
101 | |
78 | |
69 | |
63 |
User | Count |
---|---|
141 | |
106 | |
101 | |
85 | |
72 |