Percentage of total using lookup table

[Lobo1908]

Hi, 

I'm trying to calculate the percentage of total using a lookup table. 

The lookup table called 'Codes_Lookup' contains  two columns:

[Codes] - containing the list of codes 

[Desc] - containing the description of those codes 

The data table called 'Data' contains several columns, one of them is called [Error Codes] and contains codes that were used for a specific unit. each cell contains only one code. 

The 'Codes lookup' column [Codes] has a one to many relationship with the [Error Codes] column form the 'Data' table, its a one way relationship.  

I'm trying to display the percentage of tottal of codes used in the data tables:

For this I've created the following metrics:

Count = COUNTROWS('Data')

Count All = CALCULATE([Count],ALL(Data[Error Codes]))

Count (%) = DIVIDE([Count],[Count All])

When I put those metrics as values in matrix visiuals and the Codes as rows, this is not working. 

Count and Count all are the same numbers caounting occurences for specific Code. 

Count (%) in this case is alwwyas 100%

When I put the [Error Codes] form the 'Data' table instead of [Codes] from the lookup tavel   into rows it works fine but I'm not able to add descritption or filter it by additonal columns I'm planning to add to the lookup table. 

could someone support with this issue. 

[parry2k · Accepted solution]

@Lobo1908 you need to change your measure, and assuming code lookup table has relationship with data table

Count All = CALCULATE([Count],ALL(CodeLookUpTable[Codes]))