Tampa PowerBI User Group

Subject: DAX for Unrelated table

1.  DAX for Unrelated table

Posted 03-24-2017 06:50
Hi,

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 

Evaluate
SUMMARIZE ('A',
'A'[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


------------------------------