topic Re: filtering average using another table in DAX Commands and Tips

filtering average using another table

Anonymous — Sat, 23 Jul 2022 01:04:25 GMT

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

table 02

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"}))

vapid128 — Sat, 23 Jul 2022 01:11:15 GMT

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

Anonymous — Sat, 23 Jul 2022 12:36:53 GMT

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

Anonymous — Sat, 23 Jul 2022 15:07:43 GMT

Didn't work...

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

SpartaBI — Sat, 23 Jul 2022 15:21:35 GMT

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

vapid128 — Sat, 23 Jul 2022 20:15:25 GMT

I test one more time,

That should be no problem.

Can you upload the file?

Anonymous — Thu, 13 Oct 2022 00:11:49 GMT

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.