Calculate % of matching text values

[Anonymous]

Hello,

I need to calculate the % of (text) values in a table that match values in a separate master data set to verify compliance.

The example below has a master classification data set with all allowed values and the table on the right has a sample table with items and classification codes some of which are correct and some not. What measure would I need to find out the % of objects in the table on the right which have an matching classification code applied?

[v-juanli-msft]

Hi @Anonymous 

Not very clear about your requirement.

If Greg_Deckler's answer slove your problem,

please feel free to mark his answer as a solution so that others may find the topic quickly.

If not, please share a example of your expected result.

Best Regards

Maggie

[Greg_Deckler]

Compliance (Column) = 
  IF('Objects Table'[Classification Code) IN 'Master data values',1,0)

Compliance (Measure) = 
  SUM('Objects Table'[Compliance (Column)] / COUNTROWS('Objects Table')

[Anonymous · Accepted solution]

Hi, thank you for your reply.

I did a slightly different solution as the calculated column you suggested would not allow me to select values in different tables.

My solution is as follows:

Compliance Column = IF(RELATED('Master data values '[Classification Code] )='Objects Table'[Classification Code],1,0)

Then I added a calculated measure calculating the total of the compliant objects: 

NRM Compliant Objects = SUM('Objects Table'[Compliance Column])

And a final measure to give me the % ot total:

NRM Compliance = 'Objects Table'[NRM Compliant Objects]/COUNT('Objects Table'[Item Name])

It may not be the most efficien solution but adding in a column helped, thank you for the suggestion.