topic Re: Check if a value is available for all entries in other column / Intersect? in DAX Commands and Tips

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

tweidner — Fri, 20 Aug 2021 11:58:25 GMT

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

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

amitchandak — Fri, 20 Aug 2021 12:19:33 GMT

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

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

tweidner — Fri, 20 Aug 2021 17:14:45 GMT

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