MMULT array in Power BI

[Saxon10]

Hi,

In column A1 I have a description, that description contain with comma, based on the description I am trying to check certain of the character.

If criteria is matched then return Yes, If not then return No, and If column A1 is blanks then rturn as a blanks.

Search criteria is India,Belgium,Denmark,Unit of Dimension for India/Belgium/Denmark

Note: Search criteria is not allways same order. It's keep changing every line.

I am looking for DAX (New calculated column) option in order to get the desired result.

In Excel I am applying the following formula =IF(A2="","X",IF((SUM((MMULT({1,1,1},COUNTIF(A2,{"*,";"";"*,"}&{"Denmark","Belgium","India"}&{",*";",*";""}))>0)+0)=3)*(SUM((MMULT({1,1},COUNTIF(A2,"*Unit of Dimension for "&{"";"*/"}&{"Denmark","Belgium","India"}&{"/*";"*"}))>0)+0)=3),"YES","NO"))

Data:

Description

Volume,India,Belgium,Denmark,Numerator for Conversion to Base Unit of Measure,Unit of Dimension for India/Belgium/Denmark,Volume unit

Volume,India,Belgium,Denmark,Unit of Dimension for India/Belgium/Denmark,Numerator for Conversion to Base Unit of Measure,Volume unit

Denmark,India,Belgium,Numerator for Conversion to Base Unit of Measure,Unit of Dimension for India/Belgium/Denmark,Volume unit

Numerator for Conversion to Base Unit of Measure

Numerator for Conversion to Base Unit of Measure,Volume unit

Volume unit

Numerator for Conversion to Base Unit of Measure,Volume,Volume unit,Unit of Dimension for India/Belgium/Denmark,India,Belgium,Denmark

Numerator for Conversion to Base Unit of Measure,India,Belgium,Denmark,Unit of Dimension for India/Belgium/Denmark,Volume unit,Volume

Numerator for Conversion to Base Unit of Measure,Denmark,India,Volume,Unit of Dimension for India/Belgium/Denmark,Belgium,Volume unit

Numerator for Conversion to Base Unit of Measure,Volume unit,Volume,India,Denmark,Belgium,Unit of Dimension for India/Belgium/Denmark

,Volume,Belgium,Denmark,India,Unit of Dimension for India/Belgium/Denmark,Volume unit

,Volume,Volume unit,Unit of Dimension for India/Belgium/Denmark,India,Denmark,Belgium

,Gross weight

,Belgium,Denmark,India,Unit of Dimension for India/Belgium/Denmark,Volume unit,Volume

,Unit of Dimension for India/Belgium/Denmark,Volume unit,India,Volume,Denmark,Belgium

,Gross weight,Volume,Volume unit,Unit of Dimension for India/Belgium/Denmark,India,Denmark,Belgium

,India,Unit of Dimension for India/Belgium/Denmark,Volume unit,Volume,Denmark,Belgium

Gross Weight

Belgium,Denmark,India,Unit of Dimension for India/Belgium/Denmark,Volume unit,Volume,Numerator for Conversion to Base Unit of Measure

Denmark,Belgium,India,Volume,Volume unit,Unit of Dimension for India/Belgium/Denmark

Volume,Volume unit,Unit of Dimension for India/Belgium/Denmark,India,Belgium,Denmark

Denmark,India,Unit of Dimension for India/Belgium/Denmark,Volume,Volume unit,Belgium

Belgium,Denmark,India,Unit of Dimension for India/Belgium/Belgium,Denmark,Volume,Volume unit

Belgium,Denmark,India,Volume,Volume unit,Unit of Dimension for India/Belgium/Denmark,Denmark

Volume unit,Volume,Belgium,Denmark,India,Unit of Dimension for India/Belgium/Belgium,Denmark

India

India,Belgium

India,Belgium,Denmark

Belgium

Belgium,India

Belgium,India,Denmark

Denmark

Denmark,India

Denmark,India,Belgium

[CNENFRNL · Accepted solution]

@Saxon10 , my solution in Power Query isn't a strict equivalent to MMULT but only a way dedicated to your case.

Stay safe and enjoy PBI!

[Saxon10]

Thank you so much for your help and reply. Your solution working well.