Tampa PowerBI User Group

Topic: DAX for Unrelated table 

1.  DAX for Unrelated table

Posted 03-24-2017 06:50 AM

I am new to DAX.
Please help in this query.

I have 2 unrelated tables A(Master table),B having same column X_ID

A(X_ID,AName) , B(ID, X_ID,BName)

Now I would like to count no of rows in table B per X_ID 

,"NUMBER OF ProductB"
,COUNTX ( RELATEDTable('B'),[X_ID] )

The above query is returning same number for all the rows as there is no relationship establised among the tables.

Kanika soni