Forum Discussion

ryan_smith_ww's avatar
ryan_smith_ww
Frequent Visitor
5 years ago
Solved

DAX in 1st table for data in the third table. (SQL query given. Looking for Equivalent DAX)

Hi,   I've got three tables in PowerBI TableA, TableB and TableC. Relationship is one-to-many in the order TableA --> TableB --> TableC. I want to have a measure in tableA that will use rows of Ta...
  • wdx223_Daniel's avatar
    wdx223_Daniel
    5 years ago

    with the relationship, just simply use RELATEDTABLE to get rows of TableC

ryan_smith_ww's avatar
ryan_smith_ww
Frequent Visitor
5 years ago

Thanks amitchandak . TableA, TableB and TableC are in PowerBI with relationships defined between them. Unfortunately I'm still not clear on how do I convert the SQL shared above to equivalent DAX for the measure.

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

ryan_smith_ww , Please share relationship digram, based on that I suggest

  • ryan_smith_ww's avatar
    ryan_smith_ww
    Frequent Visitor
    5 years ago

    amitchandak Here's the basic diagram for the Three tables. Thanks for your help.