Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Anonymous
Not applicable

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

idmatqtdret
0123
0233
0334

 

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 6
Anonymous
Not applicable

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.

vapid128
Solution Specialist
Solution Specialist

I test one more time,

That should be no problem.

 

Can you upload the file?

Anonymous
Not applicable

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

vapid128
Solution Specialist
Solution Specialist

image.png

 

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

Didn't work...

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

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.

Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.