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

Mariam1991's avatar
Mariam1991
Helper II
9 years ago

okey ! there is no error but in result we observe that it doesn't take the join in consideration , like we calculate the count(id ) in table A without the relationship with table B ... between thanks for your feedback 

vanessafvg's avatar
vanessafvg
Community Champion
9 years ago

Can you show me how you wrote the measure?

also can you show me the screen shot of the join?

 

 

do you want to count unique id's or all the rows?