Forum Discussion

matgf's avatar
matgf
Regular Visitor
8 years ago

SQL query to DAX in Power BI

I have the following SQL Query:   SELECT * FROM [table1] INNER JOIN (SELECT [table2].table1_id, [table4].table4_id, count(*) FROM [table2] INNER JOIN [table3] ON [table2].table3_id = [table3].ta...
Greg_Deckler's avatar
Greg_Deckler
Community Champion
8 years ago

NATURALINNERJOIN is the DAX join function and you can use SUMMARIZE for grouping.

  • matgf's avatar
    matgf
    Regular Visitor
    8 years ago

    I'm using :

    Measure = CALCULATE(SUMMARIZE((NATURALINNERJOIN(<table2>;NATURALINNERJOIN(<table3>;<table4>)));"qty";count(<table2>[table1_id])))

    But I Can't make it work. 

    This is my relationship model.

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      Hi matgf,

       

      SUMMARIZE function will return table, you can't direct use it in measure.

       

      Regards,

      Xiaoxin Sheng