Forum Discussion

Drikus's avatar
Drikus
New Member
4 years ago

RELATEDTABLE

Hi I'm working my way through The Definitive Guide to DAX. In the book the below code is used to determine the top selling products. The code below makes sense to me at a high level.   I split out...
Need Help
Drikus's avatar
Drikus
New Member
4 years ago

tamerj1 
Thanks for looking at this.

 

The "BestCategories" table is the solution provided in the book. I noticed that this is also does not have a relationship with the sales table, but overall is filtering for the correct top items (Items with a sales value 2 time that of the average sales). 

 

In the table that I've created "Catefory & Subcategories" I merely split out the solution into individual steps by creating a new Table "Category & Subcategory = ALL ( 'Product'[Category], 'Product'[Subcategory] )" and then adding the measure:
"AverageSales = AVERAGEX (

'Category & Subcategory',
SUMX ( RELATEDTABLE ( Sales ), Sales[Quantity] * Sales[Net Price] )
)

Also when I tried adding relationships I got a notification :"A circular dependancy was detected". I assume its bringing the relationship in from the "Product" table.

Why would the the "BestCategories" calculate the correct amounts if it does not have any relationship?

Thanks so much