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

[DiePic]

Hi all

I need to find a value in a column in another table ... something similar like next (sql format):

select TABLE01.[col01]  ..... 

where TABLE01.[col02] = TABLE02.[col11] and TABLE01.[col03] = TABLE02.[col12] 

...

there is a way to do that?

Thanx in advance for any help or suggestion

[smpa01]

@DiePic  direct translation

EVALUATE
SELECTCOLUMNS (
    FILTER (
        TABLE01,
        ( TABLE01[col02], TABLE01[col03] )
            IN ( SUMMARIZE ( TABLE02, TABLE02[col11], TABLE02[col12] ) )
    ),
    TABLE01[col01]
)

[DiePic]

thanx @smpa01 
and if I need something like this?

select TABLE01.[col01]  ..... 

where TABLE01.[col02] = TABLE02.[col11] and TABLE01.[col03] = "my value"

[smpa01]

@DiePic 

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

[DiePic]

Hi @smpa01 
excuse me but I'm new in power bi .... where I'm mistaken

[smpa01]

@DiePic  you are using a table expresion in a meaure which is why it is failing. try this instead

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

[DiePic]

thanks a lot @smpa01 
this work well ... can you explain me where I'must use the first formula?
And please, why the use of MAX in last formula?
(excuse me but I'm really new of this word)
thnx for your patience and courtesy

[smpa01 · Accepted solution]

in Power bi, DAX is actullay iused used as a meaure in viz , which generates a scalar value for each axis dropped in a viz, which you were trying to utilize.

The first expression is a table expression which is to be used if you want dax to return a full table as opposed to a scalar value. Mainly used when you need a derived table / you want to check the derived table that you are passing within CALCULATE.

If you are new to DAX, this concept might take a while for you to grasp but looks like you work with SQL, so with patience you will get it.

DAX is neither easy nor simple, it takes a while to get used to it.

[DiePic]

@smpa01 

thank you very much