Forum Discussion
Why filter does not propogate
Hi mp390988 ,
Thank you for reaching out to Microsoft Fabric Community Forum.
Deku rosha_rosha Thank you for your quick response.
When you expand a customer in the matrix visual, Power BI filters the data based on that customer using the relationship between DimCustomer and FactInternetSales. This filter flows into the fact table and restricts the rows to only those related to that customer. From there, Power BI identifies the ProductKeys associated with that customer's transactions. Using those keys, it retrieves the corresponding product names from DimProduct. Even though there’s no direct relationship from DimCustomer to DimProduct, Power BI doesn’t need one — it leverages the fact table to bridge the two. That’s why you only see the products actually purchased by each customer, rather than a full list of all products.
If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it!
Regards,
B Manikanteswara Reddy
Hi mp390988,
Go to the Model view in Power BI.
Check if there's a relationship between:
FactInternetSales[ProductKey]
and DimProduct[ProductKey]
If it's missing, create a 1-to-many relationship from DimProduct to FactInternetSales.
Ensure the card visual is using filtered context, e.g., by changing the measure:
Instead of using:
Count of EnglishProductName = COUNT(DimProduct[EnglishProductName])
Use
Products Sold Count =
CALCULATE(
DISTINCTCOUNT(FactInternetSales[ProductKey])
)
Summary:
Visuals sync only when their tables are connected in the model.
Your card visual is not aware of the filters because it's disconnected from the customer or sales tables.
Fix it by creating proper relationships and using measures that respect filter context.