Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredGet Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
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.
@DiePic provide some sample data and expected output
Hi @smpa01 , thanx for your courtesy.
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
There is no way to have a list of data (filtering for text)?
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.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
Check out the October 2025 Power BI update to learn about new features.