Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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":
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.
I test one more time,
That should be no problem.
Can you upload the file?
Didnt worked...
Error: A table of multiple values was supplied where a single value was expected
@Anonymous you can PM me now and we could do a quick zoom to look together if you want
Measure = CALCULATE(AVERAGE(Table02[qtdret]),FILTER(Table01, Table01[classmat] in {"I","II", "IV"}))
Didn't work...
Error: A table of multiple values was supplied where a single value was expected
User | Count |
---|---|
54 | |
47 | |
19 | |
16 | |
15 |
User | Count |
---|---|
114 | |
44 | |
44 | |
28 | |
22 |