Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
54 | |
26 | |
23 | |
14 | |
11 |
User | Count |
---|---|
78 | |
63 | |
46 | |
17 | |
12 |