Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hi there,
I'm currently looking at quotes received from suppliers for various products.
What I'm failing is to create a new column or measure to identify the products each of the suppliers have quoted for.
Supplier | Product | Calculated Intersection |
A | 2 | |
A | 4 | 4 |
A | 5 | |
B | 4 | 4 |
B | 2 | |
C | 4 | 4 |
Any ideas?
Can the soltuion be probably enhanced by adding a filter on Supplier in order to determine column entries to be evaluated in the 3rd column / or a measure?
Best Regards
Tobias
@tweidner , create new column
new column =
var _dis = distinctcount(Table[Supplier])
var _disp = calculate(distinctcount(Table[Supplier]), filter(Table, [product] = earlier([product])))
return
if(_dis = _disp =, [product], blank())
@amitchandak , sorry, but dax just returns blanks... Did I overlook something?
User | Count |
---|---|
25 | |
12 | |
8 | |
6 | |
6 |
User | Count |
---|---|
26 | |
12 | |
11 | |
10 | |
6 |