Forum Discussion
filtering average using another table
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"}))
6 Replies
I test one more time,
That should be no problem.
Can you upload the file?
Measure = CALCULATE(AVERAGE(Table02[qtdret]),FILTER(Table01, Table01[classmat] in {"I","II", "IV"}))Anonymous you can PM me now and we could do a quick zoom to look together if you want
