Forum Discussion

Mariam1991's avatar
Mariam1991
Helper II
9 years ago
Solved

inner join

Hi,  i need to join 2 tables in order to calculate a meaure in power BI  i have 2 tables A and table B my aim is to add a measure in table A  in sql : select count(A.ID) from A  inner join B on ...
Need Help
  • v-ljerr-msft's avatar
    v-ljerr-msft
    9 years ago

    Hi Mariam1991,

     

    Could you try the formula below to see if it works in your scenario? :smileyhappy:

    New Column In Table A = COUNTROWS ( FILTER ( RELATEDTABLE ( 'TableB' ), 'TableB'[status] = "payed" ) )

     

    Regards

vanessafvg's avatar
vanessafvg
Community Champion
9 years ago

create a relationship if there isn't already between table table a id to table b id in the relationship view

 

measurename = calculate(countrows(['table A'), 'Table B'[Status] = "payed")

  • Mariam1991's avatar
    Mariam1991
    Helper II
    9 years ago

    thanks but i dont need a relation but an inner join between 2 table 

    more than that i do the same measure and it doesn't work :(

    • vanessafvg's avatar
      vanessafvg
      Community Champion
      9 years ago

      the relationship is an inner join.

    • Mariam1991's avatar
      Mariam1991
      Helper II
      9 years ago

      there isnt an inner join in power BI just a relationship 

      • vanessafvg's avatar
        vanessafvg
        Community Champion
        9 years ago

        Power BI is not the same as sql, creating a relationship has the same affect as an inner join, so once you have created the relationship(join) it should allow you to create the measure, have you tried and if so what error are you getting?