filtering average using another table

[Anonymous]

Hello,

I need to make a average filterig with another table.

[x] Tables have relationships
[x] one date is type string and the another is type number.

table 01

idmat |	mat  |	classmat
01  |	name01 |	I
02  |	name02 |	II
02  |	name03 |	IV
03  |	name04  |	NC

table 02

idmat	qtdret
01	23
02	33
03	34

I tried this, but not worked  because I would like a table with the classmat "I, II,IV": 

CALCULATE(

AVERAGEX('table02', table02'[qtdret]), FILTER(table01,table01[classmat] = {"I","II", "IV"}))

[Anonymous]

I just filter my table to show only the classmat I, II, III and IV. 

Other way  is use the measure lookupvalue in the table 02.

[vapid128]

I test one more time,

That should be no problem.

Can you upload the file?

[Anonymous]

Didnt worked...
Error: A table of multiple values was supplied where a single value was expected

[SpartaBI]

@Anonymous you can PM me now and we could do a quick zoom to look together if you want

[vapid128]

Measure = CALCULATE(AVERAGE(Table02[qtdret]),FILTER(Table01, Table01[classmat] in {"I","II", "IV"}))

[Anonymous]

Didn't work...

Error: A table of multiple values was supplied where a single value was expected