Forum Discussion

pstanek's avatar
pstanek
Post 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

pstanek's avatar
pstanek
Post Patron
9 years ago

Thanks I will try it,

 

Do you you know some good book, where I can learn about Query in Analytic servives in Azure. We are going to use it within monts and I need to be prepared .

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    Hi pstanek,


    Do you use Azure Analysis Service or on-premises SSAS? I would recommend you post the question about query for SSAS in the SSAS forum to get dedicated support.

    Thanks,
    Lydia Zhang