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

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now

Reply
DiePic
Resolver II
Resolver II

Help for DAX - find valueS of a column in another table

Hi all,

with @smpa01 I solve my 1st problem to to create a measure that find 1 value from another table
(post - Help for DAX - find value of a column in another table).
Now the problem is similar but I need to find more than 1 value; the case is 1 order more invoices.
I try to remove "MAX" from the previous formula suggested, but the result is an error; below the previous working formula.

Measure =
CALCULATE (
    MAX ( TABLE01[col01] ),
    FILTER (
        TABLE01,
        ( TABLE01[col02] )
            IN ( SUMMARIZE ( TABLE02, TABLE02[col11] ) )
                && TABLE01[col03] = "my value"
    )
)


any help or suggestion will be apprecied.

5 REPLIES 5
smpa01
Super User
Super User

@DiePic  provide some sample data and expected output

Did I answer your question? Mark my post as a solution!
Proud to be a Super User!
My custom visualization projects
Plotting Live Sound: Viz1
Beautiful News:Viz1, Viz2, Viz3
Visual Capitalist: Working Hrs

Hi @smpa01 , thanx for your courtesy.

DiePic_1-1676396848198.png

with your help (formula) I find all data in red evidence.
But in some rare case it's possible that we are 2 orders or other document and with 

....
MAX(TABLE01[col01])
....

I find only one row.
For that reason I think to a formula that expose all'rows finded.
....
I'll apprecied any suggestion or idea .... thanks in advance 

 

DiePic
Resolver II
Resolver II

There is no way to have a list of data (filtering for text)?

jaweher899
Impactful Individual
Impactful Individual

please try

 

Measure =
SUMX (
FILTER (
TABLE01,
( TABLE01[col02] )
IN ( SUMMARIZE ( TABLE02, TABLE02[col11] ) )
&& TABLE01[col03] = "my value"
),
TABLE01[col01]
)

Hi @jaweher899 
thaks for suggestion, but I'm searching a string value comparing strings column and SUMX return an error.

Helpful resources

Announcements
Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

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

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors