failed to get totals grouped by column-data in Power BI Visuals using AdventureWorksDW2019
Could anyone help me understand where am I doing mistake in achieving following task:
I tried to get Reseller-Name wise sales figure in AdventureWorksDW2019;
1. ResellerName a column in 'DimReseller' dimension table
2. Total_ResllerSales is the sum(SalesAmount) from FactResellerSales table
3. there is a one-to-many relation from dimension table to fact table over the column "ResellerKey". The figures indicate that the fact-table data were not being filtered based on the column 'ResellerName'.
I tried the similar approach between the tables 'DimProductCategory' and 'FactInternetSales' which is working; all these observations could be understood from the visuals -copy I attached to this email. Could anyone help me understand where is that I am missing the logic?
I believe I found the reason for sales-data haven't been filter by the column selected; and it is because the relationship is inactive between the dim-table and fact-table as shown in the figure below: