Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
23 | |
8 | |
7 | |
6 | |
6 |
User | Count |
---|---|
28 | |
11 | |
11 | |
10 | |
6 |