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
Need help to calculate count of id with same ID no. but different product
for e.g.
Vendor ID | Product |
1234 | ABC |
1234 | DEF |
1234 | XYZ |
345 | GHJ |
345 | GHJ |
6789 | WER |
8901 | RTY |
8901 | ASD |
8901 | DFG |
I have table like this. In this I want to count those vendor id which are getting repeated for different product.
For e.g. 8901 and 1234 will be counted in the above case.
Help mw with the dax function of it.
Hi @Anonymous
Place this measure in a card visual:
Measure = SUMX ( DISTINCT ( Table1[Vendor ID] ), INT ( CALCULATE ( DISTINCTCOUNT ( Table1[Product] ) ) > 1 ) )
Please mark the question solved when done and consider giving kudos if posts are helpful.
Cheers
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 |
---|---|
47 | |
24 | |
20 | |
15 | |
13 |
User | Count |
---|---|
51 | |
46 | |
39 | |
19 | |
19 |