Forum Discussion
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...
Drikus
The subcategory table is completely disconnected. You did not set any relationship. Sales amounts from sales table cannot be filtered.
Subcategory keeps data lineage referencing to the original Product table.
Please have a look at the file. The Top Categories table is calculated using the Product table lineage. However, the question is why the measures (sales amount) that are calculated based on the subcategory table are not filtered by category/subcategory. And the answer is because this table has no relationship with the sales table.
My bad, I thought the PO was talking about the derived table Subcategories on the fly. As to that materialized caculated table, I totally agree with you, only relationships matter.