Forum Discussion

pstanek's avatar
pstanek
Icon for Post Patron rankPost Patron
9 years ago

Relation N:N Direct query vs Analysis services

Cany you explain to me, how to create Table C form table B a table A step by step.   1)In direct query 2)In analysis services - live connection   It is n:n
Need Help
Tips and Tricks
Anonymous's avatar
Anonymous
Not applicable
9 years ago

Hi pstanek,

Do you create relationship using Product field between table A and table B? If that is the case, in DirectQuey mode, you can create a measure in table A using  the following DAX.

Measure = CALCULATE(SUM(B[Profit]),FILTER(A,A[Product]=RELATED(B[Product])))

Then create a table visual as shown in the following screenshot.


However, if you connect to these tables from SSAS database via “Connect Live” option, you are not able to create measure. You would need to execute the query to get desired result in SSAS data source, then import data from desired table to Power BI  Desktop.

Thanks,
Lydia Zhang