Check if a value is available for all entries in other column / Intersect?

[tweidner]

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

[amitchandak]

@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())

[tweidner]

@amitchandak , sorry, but dax just returns blanks... Did I overlook something?

Combination =

var _dis = distinctcount( 'Filter Prices'[SUPPLIER])

var _disp = calculate( distinctcount( 'Filter Prices'[SUPPLIER]), filter( 'Filter Prices', 'Filter Prices'[MM] = earlier('Filter Prices'[MM])))

return

if( _dis = _disp , 'Filter Prices'[MM], blank())