SQL to DAX inner join in Direct Query

[diogovaz]

Hi everyone,

I'm trying to create a measure that give me the SUM of value of a table A.

And the query that I have in SQL is:

SELECT SUM (VALUE)
FROM A
INNER JOIN B on A.ID = B.T_ID
INNER JOIN C on B.P_ID = C.ID
INNER JOIN D on C.P_L_ID = D.ID
INNER JOIN E on D.P_D_ID = E.ID
INNER JOIN A_2 on C.T_ID = A_2.ID
INNER JOIN F on E.P_G_M_ID = F.ID
INNER JOIN G on F.P_G_ID = F.ID
WHERE A_2 = "XPTO"
AND   D <> 2

All tables are link in dataset model but it doesn't work.

There any chance to do it by DAX ?

Thanks,

[v-chuncz-msft]

@diogovaz,

You may take a look at the following articles.

• https://www.sqlbi.com/articles/from-sql-to-dax-joining-tables/
• https://www.sqlbi.com/articles/from-sql-to-dax-filtering-data/

[diogovaz]

Thanks for you answer.

But this doesn't help me at all. 

I just seacrh and I cannot find a way to do a DAX formula that gives me a simple sum.