Forum Discussion
I don't understand filter propagation.
"Follow the arrows." Can you get there from here? In your case you cannot get from the Customer dimension to the Vending Machine dimension, as the arrows don't cooperate. So Power BI is giving you a fake result.
In your case you would need to use the Fact table and Filter transfer (via TREATAS for example) to calculate how many vending machines each customer has used in their purchases.
Super User"Follow the arrows." Can you get there from here? In your case you cannot get from the Customer dimension to the Vending Machine dimension, as the arrows don't cooperate. So Power BI is giving you a fake result.
In your case you would need to use the Fact table and Filter transfer (via TREATAS for example) to calculate how many vending machines each customer has used in their purchases.
v-menakakotaCommunity Support
Hi notofrugo90 ,
Thanks for reaching out to the Microsoft fabric community forum.I would also take a moment to thank lbendlin , for actively participating in the community forum and for the solutions you’ve been sharing in the community forum. Your contributions make a real difference.
I hope the above details help you fix the issue. If you still have any questions or need more help, feel free to reach out. We’re always here to support you .
Best Regards,
Community Support Team- v-menakakota
Hi notofrugo90 ,
I hope the above details help you fix the issue. If you still have any questions or need more help, feel free to reach out. We’re always here to support you .
Best Regards,
Community Support Team
juan_pabloHelper V
What do you mean by "fake results"? It should not affect the result per customer. Why is COUNTROWS(DIM_VENDING_MACHINE) being affected by DIM_CUSTOMER? Can you elaborate on this please?
- lbendlin
You will get all vending machines for all customers, regardless of the filter choice on DIM_Customer if you use the dimension column. If you use the fact column you get a meaningful result
- juan_pablo
But the question of notofrugo90 and mine is, why does the measure COUNTROWS(DIM_Vending_Machine) IS affected by the values of CUSTOMER_NUMBER in the DIM_CUSTOMER table as he is showing?
In the example you attached you changed the measure and the columns used, so it's a completely different model that doesn't apply for the original question.